Kizspy.me
Zoom
80
80
Migraine
7832
88
65
13
88
135
24
25
135
9
138
63
24
138
10 152
50
4
152
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
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
Question 3:
Write a query to select AppointmentID, AppointmentDate, DoctorID, DoctorFullName,
Specialty, PatientID, Patient FullName 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
1
1
2
2
3
3
4
26
5
42
6 49
7
51
8
9
61
66
10 70
2222322
11 78
12 80
13 83
14 87
15 89
16 91
17 93
18 97
19 102
20 105
21 124
126
139
24
140
27
25 144
26 153
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
Specialty
Orthopedics 49
Orthopedics 54
Orthopedics 53
Orthopedics 18
Orthopedics 78
Orthopedics 12
Orthopedics 41
Orthopedics 57
Orthopedics 13
PatientID PatientFullName
David Wilson
Sarah Wilson
Chris Davis
Chris Moore
David Williams
Emma Johnson
John Davis
James Davis
James Wilson
Orthopedics 57
Orthopedics 67
Orthopedics 4
Orthopedics 54
Orthopedics 33
Orthopedics 4
Orthopedics 12
Orthopedics 33
Orthopedics 50
Orthopedics 35
Orthopedics 13
Orthopedics 44
Orthopedics 38
James Davis
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
Orthopedics 57
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
