Zoom
4
31
Eva
Harris
1983-08-20 1234567801
[email protected]
234 Pine St
5
38
Leo
Cruz
1981-05-15
8901234568
[email protected]
901 Oak St
6
39
Mia
Kim
1982-08-21
9012345679 1234567801
[email protected] [email protected]
123 Pine St
7
61
Ines
Cox
1983-08-20 1981-05-15
234 Pine St
8
68
Quinn
Bell
8901234568
[email protected]
901 Oak St
9 69
Rosa
Scott
1982-08-21
9012345679
[email protected]
123 Pine St
10 81
Daria
Hawkins 1983-08-20 Chapman
1234567801
[email protected] 234 Pine St
11 88
Kim
12
89
Lara
13
101
Xena
1981-05-15
8901234568
[email protected]...
901 Oak St
Simmons
1982-08-21 1983-08-20
9012345679 1234567801
[email protected] [email protected] 234 Pine St
123 Pine St
Parker
14 108
Edgar
Morris
1981-05-15
8901234568
[email protected]
901 Oak St
15 109 Felicity
Harris
1982-08-21
9012345679
[email protected]
123 Pine St
16 121
Renee
Young
1983-08-20 1981-05-15
1234567801 8901234568
[email protected] 234 Pine St
[email protected]
17 128
Yanni
Hall
901 Oak St
18
129
Zoe
Lopez
1982-08-21
9012345679
[email protected]
123 Pine St
19 141
Leo
Nelson
1983-08-20 1981-05-15
1234567801 8901234568
[email protected] [email protected]...
234 Pine St
20 148
Sophia
Russell
901 Oak St
21 149
Tina
22 161
Finn
Parker
Coleman
1982-08-21
9012345679
[email protected]
1983-08-20
1234567801
[email protected] Bennett 1981-05-15 8901234568
[email protected]
123 Pine St 234 Pine St
23 168
Mia
24 169
Nina
Hernan... 1982-08-21
9012345679
25 181
Zachary Thomas
1983-08-20 1981-05-15 8901234568
1234567801
901 Oak St
123 Pine St
[email protected]@yahoo.com
234 Pine St 901 Oak St
nina.hernandez@gmail....
26 188
Gina
Lopez
27 189
Harry
James
1982-08-21
9012345679
[email protected]
123 Pine St
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:
Annointmentin AnnointmentDate
+ 100%
Doctordn FiretNama Isctlama Daseen
Close