23
141
24 151
25 162
26 171
27 177
28 185
Leo
Zoom
Nelson
[email protected]
Vera Powell 1985-01-15
[email protected]
Giselle
Hall 1989-03-30
[email protected]
Paige Hall 1985-01-15
[email protected]
Vance
1980-02-28
[email protected]
Dylan
Mitchell 1984-07-04
[email protected]
James
29 189 Harry
1982-08-21
[email protected]
30 199 Riley
Scott 1986-04-14
[email protected]
Question 5:
Picture 4.1
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.
+ 100%
Coleman
Close
