☑ Kizspy.me
4 of 4
Paper No: 5
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
NOLL
NULL
NULL
3
21
Dr. David Miller
NULL
NOLL
NULL
NULL
NULL
NULL
NULL
HOLL
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
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
13
Dr. Emma Jules
129
12
12
12
12
Dr. Emma Wilson
NULL
NULL
NULL
Omeprazole Inject once a week
Paraceta... Take every 8 ho...
Aspirin Inject once a week
NULL
NULL
NULL
NULL
NULL
13
13
25
25
Dr. James Brown
NULL
NULL
NULL
2020-06-14 00:00:00.000 2
2020-06-14 00:00:00.000 2
2020-06-14 00:00:00.000 2
NULL
NULL
Sarah Johnson
Sarah Johnson
Sarah Johnson
NULL
NULL
NULL
NULL
14
9
14 9
Dr. James Johns... 150
Omeprazole Apply topically
2020-08-23 00:00:00.000 42
James Davis
15
15 9
Dr. James Johns... 151
Paraceta... 2 pills daily
2020-08-23 00:00:00.000 42
James Davis
16 7
Dr. James M
Miller NULL
NULL
NULL
NOLL
NULL
NULL
NULL
WOLL
17
18
Dr. John Smith
NULL
NULL
NOLL
NULL
NULL
NULL
NULL
NULL
18
6
Dr. John Taylor
NULL
NULL
NULL
NULL
NULL
NULL
19 14
Dr. John Wilson
NOL
NULL
NULL
NULL
NULL
NULL
NULL
20 23
Dr. Laura Miller
54
Ibuprofen
2 pills daily
21 3
Dr. Laura Moore
312
Aspirin
2 pills daily
2020-05-30 00:00:00.000 32
2020-06-24 00:00:00.000 57
Laura Davis
James Davis
22 3
Dr. Laura Moore
313
Amoxicillin
Dr. Laura Moore
314
Inject once a week
Paraceta... 2 pills daily
2020-06-24 00:00:00.000 57
2020-06-24 00:00:00.000 57
James Davis
James Davis
24
22
Dr. Michael Brown 103
25
10
Dr. Michael John... 279
Omeprazole Take every 8 ho... 2020-06-24 00:00:00.000 29
Omeprazole 1 pill daily
John Davis
26
8
Dr. Michael Moore 65
Metformin
.
1 pill daily
2020-05-22 00:00:00.000 40
2020-09-08 00:00:00.000 21
Emily Taylor
Laura Smith
27
17
Dr. Sarah Brown
NULL
NULL
NULL
28 20
Dr. Sarah Davis
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
29 4
Dr. Sarah Jones
298
30 4
Dr. Sarah Jones
299
31
19
Dr. Sarah Williams NULL
Amoxicillin Apply topically
2020-07-23 00:00:00.000 50
Ibuprofen Inject once a week 2020-07-23 00:00:00.000 50
NULL
NULL
NULL
Laura Moore
Laura Moore
NULL
NULL
Picture 4.1
Question 5:
Write a query to display DoctorID, FullName, Specialty, NumberOfAppointments,
SumOfBilling TotalAmount for all doctors having the specialty 'Neurology'; where, for each
doctor:
-NumberOfAppointments is the total number of appointments in 2021 and 2022 (based on
Zoom
+ 100%
Close
