Kizspy.me
Question 4:
Picture 3.1
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, Doctor FullName,
PrescriptionID, Medicine, Dosage, PrescriptionDate, 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 PrescriptionDate for prescriptions of the same doctor as follows:
Zoom
4 of 4
Paper No: 2
DoctorID DoctorFullName
PrescriptionID Medicine Dosage
PrescriptionDate
PatientID PatientFullName
1
16
Dr. Chris Taylor
NULL
NULL
NULL
NULL
NULL NULL
2
1
Dr. David Davis
NULL
NULL
NULL
NULL
NULL
NULL
3 21
Dr. David Miller
NULL
NULL
NULL
NULL
NULL
NULL
4
2
Dr. David Taylor NULL
NULL
NULL
NULL
NULL NULL
5 5
Dr. David Wilson
NULL
NULL
NULL
NULL
NULL
NULL
6
15
Dr. Emily Williams
NULL
NULL
NULL
NULL
NULL NULL
7
11
Dr. Emma Johnson NULL
NULL
NULL
NULL
NULL
NULL
8
24
Dr. Emma Jones
NULL
9
13
Dr. Emma Jules
127
10 13
Dr. Emma Jules
128
11
13
Dr. Emma Jules
129
NULL
Omeprazole Inject once a week
Paraceta... Take every 8 ho...
Aspirin
NULL
NULL
NULL
NULL
2020-06-14 00:00:00.000 2
Sarah Johnson
Inject once a week
12
12
Dr. Emma Wilson
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
NULL
Sarah Johnson
Sarah Johnson
NULL
NULL
NULL
NULL
NULL
14 9
Dr. James Johns... 150
Omeprazole Apply topically
2020-08-23 00:00:00.000 42
James Davis
15 9
Dr. James Johns 151
Paraceta... 2 pills daily
2020-08-23 00:00:00.000 42
James Davis
16 7
Dr. James Miller
NULL
NULL
NULL
NULL
NULL
NULL
17 18
Dr. John Smith
NULL
NULL
NULL
NULL
NULL
NULL
18 6
Dr. John Taylor
NULL
NULL
NULL
NULL
NULL
NULL
19 14
Dr. John Wilson
NULL
NULL
NULL
NULL
NULL
NULL
20 23
Dr. Laura Miler
54
Ibuprofen
2 pills daily
2020-05-30 00:00:00.000 32
Laura Davis
21 3
Dr. Laura Moore
312
Aspirin
22
3
Dr. Laura Moore
313
Amoxicillin
2 pills daily
Ininct once a week
2020-06-24 00:00:00.000 57
2020.06.24.00-00-00 000 57
James Davis
James Davis
+ 95%
Close
