Zoom
3 of 3
Paper No: 4
DoctorID
FirstName
LastName
Phone Number
Email
DepartmentID
1
1
John
Doe
1234567890
[email protected]
3
2
9
Elizabeth Hernandez
9012345678
[email protected] 6
3
11
Jennifer
Wilson
1234567891
[email protected]
3
4
19
Edward
Perez
9012345679
[email protected]
6
5
23
Betty
Clark
3456789014
[email protected]
3
6
29
Melissa
Young
9012345680
[email protected] 3
7
40
Samuel
Carter
0123456782
[email protected]
3
8
41
Rachel
Mitchell
1234567894
[email protected]
6
9 49
Sharon
Edwards
9012345683
[email protected] 6
10 50
Frank
Collins
3
0123456784
[email protected]
Picture 2.1
Question 3:
Write a query to select AppointmentID, AppointmentDate, PatientID, FirstName, LastName,Reason, Status for all appointments of the patient whose first name is 'Hannah' and last name is 'Garcia', where FirstName and LastName are respectively the first name and last name of the patient, as follows:
AppointmentID
AppointmentDate
PatientID
FirstName
LastName
Reason
Hannah Garcia
Status
1
3
2020-03-22 11:15:00.000 8
Skin examination
Completed
2
43
2023-07-24 14:00:00.000 8
3 65
2020-08-15 11:00:00.000 8
4
69
2020-12-12 15:00:00.000 8
Hannah Garcia
Hannah Garcia
Hannah Garcia
Vision exam
Completed
Check for allergies
Completed
Mental health evaluation
Completed
Picture 3.1
Question 4:
Write a query to display PatientID, FirstName, LastName and DateOfBirth of all distinct patients who have done at least one test among 'Flu Test', 'Blood Sugar Test' and 'GeneticTesting'. Display the results in ascending order of PatientID as follows:
+ 91%
Close
