150
12 197
Parker
Hall
1995-07-19
1980-02-28
Picture 4.1
Question 5:
Write a query to display TestID, Name, NumberOfAppointments corresponding to each of the five tests respectively named 'Tissue Biopsy', 'Chlamydia Test', 'Stool Test', 'Skin Allergy Test', 'HIV Test'; where NumberOfAppointments of a test is the number of appointments in 2023 in which the corresponding test is required. Display the results in descending order of NumberOfAppointments, then in ascending order of TestID for rows having the same NumberOfAppointments as follows:
TestID
39
18
Name
Tissue Biopsy
NumberOfAppointments
3
2
2
HIV Test
34
Stool Test
45
23
Chlamydia Test 2
Skin Allergy Test 0
Question 6:
Picture 5.1
1
2
3
4
5
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
