☑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 Prescription Date for prescriptions of the same doctor as follows:
4 of 4
Paper No: 5
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
21
Dr. David Miller
NULL
NULL
NULL
NULL
NULL
NULL
4
2
Dr. David Taylor
NULL
NULL
NULL
NULL
NULL NULL
5
Dr. David Wilson
NULL
NULL
NULL
NULL
NULL
NULL
15
Dr. Emily Williams NULL
NULL
NULL
NULL
NULL
NULL
11
11
Dr. Emma Johnson NULL
NULL
NULL
NULL
NULL
NULL
24
24
Dr. Emma Jones
NULL
NULL
13
15
Dr. Emma Jules
127
10
13
Dr. Emma Jules
128
120
11
13
Dr. Emma Jules
129
12
12
Dr. Emma Wilson
NULL
13 25
Dr. James Brown
NULL
NULL
NULL
NULL
NULL
Omeprazole Inject once a week 2020-06-14 00:00:00.000 2
Paraceta...
Take every 8 ho... 2020-06-14 00:00:00.000 2
Aspirin Inject once a week 2020-06-14 00:00:00.000 2
NULL
NULL
NULL
NULL
Sarah Johnson
Sarah Johnson
Sarah Johnson
NULL
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
NULL
NULL
Zoom
- FUO
+ 100%
Close
