TestID
Name
NumberOfAppointments
3
2
39
18
34
45
23
Tissue Biopsy
HIV Test
Stool Test 2
Chlamydia Test 2
Skin Allergy Test 0
Picture 5.1
1
2
3
4
5
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
Zoom
+ 100%
Close
