☑Kizspy.me
1
6
Hypertension Surgery
18
Dr. John Smith
39
David Jones
7
Hypertension Surgery
25
Dr. James Brown 4
James Johnson
3
8
4
18
5
6
7
31
8
9
46
OFERTE222222
10
11 79
12
13
96
14
15
16 126
17
18
19
20
21
23
24
* 2253429988
Hypertension Regular monitoring 9
Hypertension Medication
Dr. James Johnson 4
James Johnson
13
Dr. Emma Jules
60
Michael Wilson
Hypertension Regular monitoring 22
Hypertension Dietary changes
Dr. Michael Brown 44
Emma Smith
23
Dr. Laura Miller
32
Laura Davis
Hypertension Medication
23
Dr. Laura Miller
7
Sarah Williams
Hypertension Regular monitoring 8
Hypertension Medication
Dr. Michael Moore
72
Michael Moore
25
Dr. James Brown
56
Chris Johnson
Hypertension Regular monitoring 2
Hypertension Physical therapy
Dr. David Taylor
37
Sarah Miller
15
Dr. Emily Williams
65
Jane Miller
Hypertension Physical therapy
2
Dr. David Taylor
13
James Wilson
Hypertension Dietary changes
3
Dr. Laura Moore
66
Emma Smith
119
Hypertension Medication
23
Dr. Laura Miller
18
Chris Moore
121
Hypertension Physical therapy
23
Dr. Laura Miller
1
James Smith
Hypertension Surgery
7
Dr. James Miller
44
Emma Smith
Hypertension Surgery
21
Dr. David Miller
51
Jane Brown
Hypertension Surgery
25
Dr. James Brown
24
Chris Wilson
Hypertension Physical therapy
10
Dr. Michael John... 40
Emily Taylor
146
156
160
Hypertension Physical therapy
Hypertension Medication
Hypertension Physical therapy 25
Hypertension Regular monitoring 24
Hypertension Rest
9
Dr. James Johnson 71
Sarah Miller
14
Dr. John Wilson
28
John Taylor
Dr. James Brown
21
Laura Smith
Dr. Emma Jones
46
Jane Wilson
6
Dr. John Taylor
49
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
natient's last name Order the results in ascending order of DoctorFullName then in
+ 100%
Close
