4 of 4
Paper No: 11
PatientID
FirstName
LastName
DateOfBirth
1
11
Kyle
Lopez
1983-08-20
2
53
Anna
Chapman
1988-06-10
3
66
Oscar
Jenkins
1996-12-12
4
88
Kim
Chapman
1981-05-15
5
111
Holly
Rivera
1985-01-15
6
141
Leo
Nelson
1983-08-20
7
147
Ruth
Harris
1990-01-02
8
159
David Richardson
1986-04-14
9
162
Giselle Hall
1989-03-30
10
195
Noah
Lewis
1984-05-30
11
196
Olivia
Clark
1995-07-19
12
197
Parker Hall
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
Zoom
+ 100%
Close
