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).

Position NumStaff
PlasticNurse 1
Nurse 1
DermNurse 1

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

Expert's Answer

help

Hire Expert 

Get a Professional Help


200
Select FileChangeRemove

TOP