23
24
141
151
25 162
26 171
27 177
28 185
Leo
Zoom
Nelson 1983-08-20
[email protected]
Vera Powell 1985-01-15
[email protected]
Giselle Hall 1989-03-30
[email protected]
Paige Hall
1985-01-15
[email protected]
Vance Coleman 1980-02-28
[email protected]
Dylan Mitchell 1984-07-04
[email protected]
29 189 Harry
James 1982-08-21
[email protected]
30 199 Riley
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
Close
Paper No 3
+ 94%
