12 72
Ursula
Yasmin
14
86
Ivy
Harris
Collins
Ward
1990-03-22
[email protected]
1995-07-19
[email protected]
1996-12-12
[email protected]
15
94
16 96
Quincy
Steve
Bell
1992-12-05
[email protected]
Powell
1995-07-19
[email protected]
17 100
Wendy
Vasquez
1991-09-09
wendy.vasquez@yahoo....
18 106
Carl
Scott
19 108
Edgar
Morris
1996-12-12
[email protected]
1981-05-15
[email protected]
20 111
Holly
Rivera
1985-01-15
[email protected]
21
115
Lana
Fisher
1984-05-30
[email protected]
22
139
Jack
Gordon
1986-04-14
[email protected]
23 141
Leo
Nelson
1983-08-20
[email protected]
24 151
Vera
Powell
1985-01-15
[email protected]
25 162
Giselle
Hall
1989-03-30
[email protected]
26 171
Paige
Hall
1985-01-15
[email protected]
27 177
Vance
Coleman
1980-02-28
[email protected]
28 185 Dylan
Mitchell
1984-07-04
[email protected]
29 189 Harry
James
30 199 Riley
Scott
1982-08-21
[email protected]
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
Zoom
+ 100%
Close
