Zoom
int
varchar(30)
Picture 1.1
Question 2:
Display all doctors of the departments with DepartmentID = 3 or DepartmentID = 6 as follows:
3 of 3
Paper No: 6
DoctorID
FirstName LastName
Phone Number Email Doe 1234567890
DepartmentID
1
1
John
[email protected]
3
2
9
Elizabeth Hernandez
9012345678
[email protected] 6
3
11
Jennifer Wilson
1234567891
[email protected] [email protected]
3
4
19
Edward Perez
9012345679
6
5
23
Betty Clark Melissa Young
3456789014
[email protected] 9012345680
3
6 29
[email protected] 3
7 40
Samuel Carter
8 41
Rachel Mitchell
0123456782 1234567894
[email protected]
3
[email protected]
6
9 49
Sharon Edwards
10 50
Frank
9012345683
[email protected] 6
[email protected]
Collins 0123456784
3
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 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 2022-01-01 09:45:00.000 5
Linda
Brown
Review of test results
4
151
Linda
Brown
Routine check-up
5 227
2024-04-10 09:00:00.000 5
Linda
Brown
Chronic illness management Skin care consultation
6 254
2024-06-24 11:00:00.000 5
Linda
Brown
Picture 3.1
Question 4:
+ 100%
Close
