Question 5. How many support staff are there in each of the listed position? Display the position and number of support staff in descending order of the latter (number of support staff).

Question 5                                                                                                                   2 Marks

How many support staff are there in each of the listed position?  Display the position and number of support staff in descending order of the latter (number of support staff).

select s.Position, count(s.id) as NumStaff  from SupportStaff s Group by s.Position order By  s.Position DESC