4 45
5
23
Chlamydia Test 2
Skin Allergy Test 0
Picture 5.1
Question 6:
Write a query to display, for each department, all the doctors who have the highest number of medical records. The results must include DepartmentID, Name, DoctorID,DoctorFullName and NumberOfRecords, where DoctorFullName is the concatenation of the
5 of 5
Paper No: 11
doctor's first name, a whitespace and the doctor's last name. The NumberOfRecords of a doctor is the total number of medical records associated with that doctor.
DepartmentID Name
DoctorID
DoctorFullName
NumberOfRecords
1
1
Cardiology 35
Rebecca Green
12
2
2
Neurology 14
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 Virginia Nelson
5
8 5
Dermatology 39
5
9 6
Radiology 49
Sharon Edwards
7
10 7
Oncology
30
Anthony Allen
7
11
8
Emergenc... 43
Justin Roberts
8
+ 100%
Zoom
Close
