Kizspy.me
80
80
88
65
13
88
8
135
24
25
135
9
138
63
24
138
10 152
50
4
152
ingraine Surgery
Migraine Surgery Patient diagnosed with Migraine. Treatment Surg.
Infection Surgery Patient diagnosed with Infection. Treatment: Surg
Hypertension Surgery Patient diagnosed with Hypertension. Treatment:
Migraine Surgery Patient diagnosed with Migraine. Treatment: Surg
Diabetes Surgery Patient diagnosed with Diabetes. Treatment: Surg
Picture 2.1
Zoom
Question 3:
2020/02/04 00.00.00.000
2020-01-24 00:00:00.000
2020-05-08 00:00:00.000
2020-05-10 00:00:00.000
2020-05-11 00:00:00.000
2020-07-23 00:00:00.000
Write a query to select AppointmentID, AppointmentDate, DoctorID, DoctorFullName,
Specialty, PatientID, PatientFullName for all appointments of all doctors having the specialty
'Orthopedics'; where PatientFullName is the concatenation of the patient's first name, a
white space and the patient's last name, as follows:
AppointmentID AppointmentDate
DoctorID DoctorFullName
Specialty PatientID PatientFullName
1
1
2
2
3
3
4
26
5
42
6 49
7
51
8
9
61
66
10 70
2 2 2 2 2 3 3 3 22
11
12 80
13 83
78
14 87
15 89
16 91
17 93
20
21 124
18 97
19 102
105
22 126
23 139
24 140
25
144
26
153
27
160
2022-03-01 00:00:00.000 1
2021-06-02 00:00:00.000 11
2021-05-06 00:00:00.000 1
2019-12-21 00:00:00.000 6
2024-03-29 00:00:00.000 6
2021-09-24 00:00:00.000 6
2020-03-01 00:00:00.000 1
2022-12-01 00:00:00.000 11
2021-01-17 00:00:00.000 6
2021-01-12 00:00:00.000 1
2024-06-21 00:00:00.000 1
2020-01-24 00:00:00.000 6
2019-08-29 00:00:00.000 11
2022-01-12 00:00:00.000 11
2021-08-22 00:00:00.000 1
2019-05-17 00:00:00.000 1
2020-01-30 00:00:00.000 7
2020-04-28 00:00:00.000 11
2021-12-26 00:00:00.000 1
2023-03-26 00:00:00.000 7
2022-01-07 00:00:00.000 7
2019-04-01 00:00:00.000 7
2024-04-04 00:00:00.000 7
2022-07-25 00:00:00.000 6
2024-06-20 00:00:00.000 6
2021-07-06 00:00:00.000 11
2019-08-06 00:00:00.000 6
Dr. David Davis
Dr. Emma Johnson
Dr. David Davis
Dr. John Taylor
Dr. John Taylor
Dr. John Taylor
Dr. David Davis
Dr. Emma Johnson
Dr. John Taylor
Dr. David Davis
Dr. David Davis
Dr. John Taylor
Dr. Emma Johnson Orthopedics 26
Dr. Emma Johnson Orthopedics 49
Dr. David Davis
Dr. David Davis
Dr. James Miller
Dr. Emma Johnson
Dr. David Davis
Dr. James Miller
Dr. James Miller
Dr. James Miller
Dr. James Miller
Dr. John Taylor
Dr. John Taylor
Orthopedics 49
Orthopedics 54
Orthopedics 53
Orthopedics 18
Orthopedics 78
Orthopedics 12
Orthopedics 41
Orthopedics 57
Orthopedics 13
David Wilson
Sarah Wilson
Chris Davis
Chris Moore
David Williams
Emma Johnson
John Davis
James Davis
James Wilson
Orthopedics 57
James Davis
Orthopedics 67
Orthopedics 4
Orthopedics 33
Orthopedics 4
Orthopedics 12
Orthopedics 33
Orthopedics 50
Orthopedics 35
Orthopedics 13
Orthopedics 44
Orthopedics 38
Orthopedics 54
Orthopedics 57
Emma Taylor
James Johnson
David Jones
David Wilson
John Taylor
James Johnson
Emma Johnson
John Taylor
Laura Moore
Jane Moore
James Wilson
Emma Smith
Jane Williams
Sarah Wilson
James Davis
Dr. Emma Johnson Orthopedics 72
Dr. John Taylor Orthopedics 49
Michael Moore
David Wilson
Picture 3.1
Question 4:
Write a query to display all the prescriptions prescribed from 15th May 2020 to 15th
+ 95%
Close
