prescription in this period. The results must include DoctorID, DoctorFullName,
☑ Kizspy.me 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: 12
Zoom
DoctoriD DoctorFullName
PrescriptionID Medicine
Dosage
PrescriptionDate
PatientID PatientFullName
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
2
Dr. David Taylor
NULL
NULL
NULL
NULL
NULL
NULL
5
5
Dr. David Wilson
NULL
NULL
NULL
NULL
NULL
NULL
15
15
Dr. Emily Williams
NULL
NULL
NULL
NULL
NULL NULL
7
11
Dr. Emma Johnson NULL
NULL
NULL
NULL
NULL NULL
24
Dr. Emma Jones
NULL
15
13
Dr. Emma Jules
127
10
13
Dr. Emma Jule
Dr. Emma Jules
128
11
13
Dr. Emma Jules
129
NULL
NULL
Omeprazole Inject once a week
Paraceta... Take every 8 ho...
Aspirin
12 12
Dr. Emma Wilson
NULL
NULL
NULL
NULL
2020-06-14 00:00:00.000 2
2020-06-14 00:00:00.000 2
Inject once a week 2020-06-14 00:00:00.000 2
NULL
NULL
NULL
Sarah Johnson
Sarah Johnson
Sarah Johnson
NULL
NULL
13 25
Dr. James Brown
NULL
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
+ 100%
Close
