Kizspy.me
23 156
24 160
Hypertension Regular monitoring 24
Hypertension Rest
Dr. Emma Jones
46
Jane Wilson
6
Dr. John Taylor
49
David Wilson
Picture 3.1
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 PrescriptionDate for prescriptions of the same doctor as follows:
4 of 4
Paper No: 5
DoctoriD DoctorFullName
PrescriptionID Medicine
Dosage
PrescriptionDate
1
16
Dr. Chris Taylor
NULL
NULL
NULL
NULL
2
1
Dr. David Davis
NULL
NULL
NULL
NULL
21
Dr. David Miller
NULL
NULL
NULL
NULL
PatientID PatientFullName
NULL NULL
NULL NULL
NULL NULL
2
Dr. David Taylor
NULL
NULL
NULL
NULL
NULL NULL
6
5
Dr. David Wilson
NULL
NULL
NULL
NULL
NULL NULL
15
Dr. Emily Williams
NULL
NULL
NULL
NULL
NULL NULL
11
Dr. Emma Johnson NULL
NULL
NULL
NULL
NULL
NULL
24
24
Dr. Emma Jones
NULL
13
13
Dr. Emma Jules
121
127
10
13
Dr. Emma Jules
128
11
13
Dr. Emma Jules
129
12 12
Dr. Emma Wilson
NULL
NULL
NULL
NULL
Omeprazole Inject once a week
Paraceta... Take every 8 ho...
Aspirin Inject once a week
Inject
NULL
NULL
NULL
NULL
NULL
2020-06-14 00:00:00.000 2
Sarah Johnson
2020-06-14 00:00:00.000 2
2020-06-14 00:00:00.000 2
NULL
Sarah Johnson
Sarah Johnson
NULL
NULL
13 25
Dr. James Brown
NULL
NULL
NULL
NULL
NULL
NULL
14 9
Dr. James Johns... 150
15 9
Dr. James Johns... 151
Omeprazole Apply topically
Paraceta... 2 pills daily
16 7
Dr. James Miller
NULL
NULL
NULL
2020-08-23 00:00:00.000 42
2020-08-23 00:00:00.000 42
NULL
NULL
James Davis
James Davis
NULL
Zoom
+ 100%
Close
