Zoom
5 of 5
Paper No: 7
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
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
+ 100%
Close
