TO
Collins 0123430/04
[email protected]
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
1 39
2
3
4
42
83
151
5 227
6 254
AppointmentDate
DoctorID FirstName LastName Reason
Linda Brown
2023-03-10 08:00:00.000 5
Linda Brown
Linda
Brown
Routine exam
Wellness exam
2023-06-12 09:15:00.000 5
2022-02-22 14:15:00.000 5
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 Brown
Chronic illness management
2024-06-24 11:00:00.000 5
Skin care consultation
Question 4:
Picture 3.1
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
