Kizspy.me 26
222
144
153
160
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. John Taylor Orthopedics 57
Dr. Emma Johnson Orthopedics 72
Dr. John Taylor Orthopedics 49
James Davis
Michael Moore
David Wilson
Picture 3.1
Zoom
Question 4:
Write a query to display all the prescriptions prescribed from 15th May 2020 to 15th
September 2020, inclusive, of all doctors, including also doctors who did not prescribe any
prescription in this period. The results must include DoctorID, DoctorFullName,
PrescriptionID, Medicine, Dosage, Prescription Date, PatientFullName; where
PatientFullName is the concatenation of the patient's first name, a white space and the
patient's last name. Order the results in ascending order of DoctorFullName, then in
ascending order of Prescription Date for prescriptions of the same doctor as follows:
4 of 4
Paper No: 4
DoctorID DoctorFullName
PrescriptionID Medicine
Dosage
PrescriptionDate
1
16
Dr. Chris Taylor
NULL
NULL
NULL
NULL
PatientID PatientFullName
NULL
NULL
1
Dr. David Davis
NULL
NULL
NULL
NULL
NULL
NULL
21
Dr. David Miller
NULL
NULL
NULL
NULL
NULL
NULL
2
2
Dr. David Taylor
NULL
NULL
NULL
NULL
NULL NULL
5
Dr. David Wilson
NULL
NULL
NULL
NULL
NULL
NULL
NULL NULL
15
Dr. Emily Williams
NULL
NULL
NULL
NULL
NOLL
NULL NULL
7
11
Dr. Emma Johnson NULL
NULL
NULL
NULL
NULL
NULL
8
24
Dr. Emma Jones
NULL
NULL
13
Dr. Emma Jules
127
10 13
Dr. Emma Jules
128
11
13
Dr. Emma Jules
129
12 12
Dr. Emma Wilson
NULL
NULL
Omeprazole Inject once a week
Paraceta... Take every 8 ho...
Aspirin Inject once a week
NULL
NULL
NULL
NULL
13 25
Dr. James Brown
NULL
NULL
NULL
NULL
2020-06-14 00:00:00.000 2
2020-06-14 00:00:00.000 2
2020-06-14 00:00:00.000 2
2020
NULL
Sarah Johnson
Sarah Johnson
Sarah Johnson
NULL
NULL
NULL
NULL
NULL
14 9
Dr. James
Johns...
150
Omeprazole Apply topically
15
9
Dr. James Johns... 151
Paraceta... 2 pills daily
2020-08-23 00:00:00.000 42
2020-08-23 00:00:00.000 42
James Davis
James Davis
16 7
Dr. James Miller
NULL
NULL
NULL
NULL
17
19
Dr John Smith
NELL
NILL
NILL
NII
NULL
N
NULL
NULL
- FUO
+ 100%
Close
