doctor is the total number of medical records associated with that doctor.
DepartmentID
Name
DoctorID DoctorFullName
NumberOfRecords
1
1
2 2
Cardiology 35
Neurology 14
Rebecca Green
12
Jessica Taylor
7
3
2
Neurology 31
Deborah Sanchez 7
4 3
Pediatrics
1
John Doe
10
5
4
Orthopedics 12
David Anderson
7
6 5
Dermatology 4
Michael Williams 5
7 5
Dermatology 32
Joshua Wright
5
8
5
Dermatology 39
Virginia Nelson 5
9 6
Radiology 49
Sharon Edwards
7
10 7
Oncology
30
Anthony Allen
7
11 8
Emergenc... 43
Justin Roberts
8
12 9
Psychiatry
24
George Rodrigu... 4
13 10
General S...
48
Keith Evans
10
Picture 6.1
Question 7:
Write a query to display, for each year of the appointments table, the total cost of tests conducted for appointments in this year of each of the five departments: 'Cardiology','Neurology', 'Pediatrics', 'Dermatology' and 'Oncology'. The results must include DepartmentID, Name, Year and TotalCost as shown in the following figure. For example, the first row in the figure indicates that the total cost for tests conducted for appointments in 2020 in the 'Cardiology' department is 915. Note that the TotalCost for a given department in a given year must be NULL if no test was performed in that year for appointments in that department (as shown in the 17th row of the figure).
Zoom
+ 100%
Close
