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