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
1 3
2
3
43
65
AppointmentDate
2020-03-22 11:15:00.000 8
PatientID FirstName LastName Reason
Hannah Garcia
2023-07-24 14:00:00.000 8
2020-08-15 11:00:00.000 8
Hannah Garcia
Hannah Garcia
Skin examination
Vision exam
Check for allergies
Completed Completed
4 69
2020-12-12 15:00:00.000 8
Hannah Garcia
Mental health evaluation
Status
Completed Completed
Picture 3.1
Question 4:
Write a query to display PatientID, FirstName, LastName, DateOfBirth, Email of all distinct patients who had appointments with doctors of the department 'Cardiology' from the year 2021 to the year 2024; display the result in ascending order of PatientID as in the following
figure:
4 of 4
Paper No: 12
+ 100%
Zoom
Close
