Gina Lopez
27 189 Harry
James
gina.lopez@yah
1982-08-21 9012345679
[email protected]
123 Pine St
Picture 2.1
Zoom
Question 3:
Write a query to select AppointmentID, AppointmentDate, DoctorID, FirstName, LastName,Reason for all appointments of the doctor whose first name is 'Linda' and last name is 'Brown', where FirstName and LastName are respectively the first name and last name of the doctor, as follows:
AppointmentID
AppointmentDate
DoctorID FirstName
LastName Reason
1
39
2023-03-10 08:00:00.000 5
Linda Brown
Routine exam
2
42
2023-06-12 09:15:00.000 5
Linda
Brown
Wellness exam
3
83
2022-02-22 14:15:00.000 5
Linda Brown Linda Brown
Review of test results
4
151
2022-01-01 09:45:00.000 5
Routine check-up
5 227
2024-04-10 09:00:00.000 5
Linda Brown
Chronic illness management
6 254
2024-06-24 11:00:00.000 5
Linda
Brown
Skin care consultation
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:
+ 100%
Close
