Question 3:
Zoom
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
39
42
83
151
227
AppointmentDate
DoctorID FirstName
2023-06-12 09:15:00.000 5
LastName Reason
Linda Brown
2023-03-10 08:00:00.000 5
Linda Linda Brown Brown
Routine exam
Wellness exam
2022-02-22 14:15:00.000 5
Review of test results
2022-01-01 09:45:00.000 5
2024-04-10 09:00:00.000 5
Linda Brown
Linda
Brown
Routine check-up
Chronic illness management
2024-06-24 11:00:00.000 5
Linda Brown
Skin care consultation
1
2
3
4
5
6 254
Question 4:
Picture 3.1
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
