title: GROUP BY in SSMS vs MySql workbench
body: <p><strong>Question :</strong> Write a query that obtains two columns. The first column must contain annual salaries higher than 80,000 dollars. The second column, renamed to “emps_with_same_salary”, must show the number of employees contracted to that salary. Lastly, sort the output by the first column. Need output in SSMS.</p>
  <p><strong>Sol:</strong></p>
  <p>Please note, this solution below gives the output in MySql Workbench but not in SSMS.</p>
  <p>select salary, count(emp_no) as emps_with_same_salary<br />
  from salaries
  where salary &gt; '80000'
  group by emp_no;</p>
  <p><strong>OUTPUT:</strong></p>
  <p>salary      emps_with_same_salary</p>
  <p>'80001'       , '7'</p>
  <p>'80007'        , '11'</p>
  <p>'80056'        , '5'</p>