6 of 6
Paper No: 10
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).
DepartmentID
1
5
2
7
3
Name
Year
Total Cost
Cardiology
2020
915.00
Dermatology
2020
295.00
Neurology
2020
1250.00
Oncology
2020
335.00
Pediatrics
2020
60.00
1
2
3
4
5
Zoom
Close
+ 100%
