29 189 Harry Riley James 1982-08-21
[email protected]
Scott 1986-04-14
[email protected]
Picture 4.1
Question 5:
Write a query to display DoctorID, FirstName, LastName, DepartmentName,NumberOfAppointments corresponding to each doctor of two departments named 'Pediatrics' and 'General Surgery'; where NumberOfAppointments is the number of 'Completed' appointments in 2023 of each doctor. Order the results in descending order of NumberOfAppointments, then in ascending order of DoctorID for rows having the same NumberOfAppointments as in the following figure. Note that all doctors of these two departments must be displayed.
5 of 5
Paper No: 10
DoctorID
1
FirstName
John
LastName
Doe
DepartmentName NumberOfAppointments
Close
+ 100%
Zoom
Pediatrics
2
1
