☑Kizspy.me
Zoom
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
NOLL
NULL
NULL
NULL
3
21
Dr. David Miller
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
4
2
Dr. David Taylor
NULL
NULL
NULL
NULL
NULL
NULL
5
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
8
24
Dr. Emma Jones NULL
NULL
NULL
NULL
NULL
NULL
9
13
12
Dr. Emma Jules
127
10
13
Dr. Emma Jules
128
11
13
13
Dr. Emma Jules
129
Aspirin
12
12
12
Dr. Emma Wilson
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
Inject once a week 2020-06-14 00:00:00.000 2
NULL
Sarah Johnson
Sarah Johnson
Sarah Johnson
NULL
NULL
NULL
13
14
O
19
15 9
16 7
17 18
18 6
19
20 23
21 3
22 3
3
24
22
25
26
8
26
25
Dr. James Brown
NULL
NULL
NULL
NULL
NULL
NULL
Dr. James Johns... 150
Omeprazole Apply topically
2020-08-23 00:00:00.000 42
James Davis
Dr. James Johns... 151
Paraceta... 2 pills daily
2020-08-23 00:00:00.000 42
James Davis
Dr. James Miller
NULL
NULL
NULL
NULL
NULL
NULL
Dr. John Smith
NULL
NULL
NULL
NULL
NULL
NULL
Dr. John Taylor
NULL
NULL
NULL
NULL
NULL
NULL
HOLL
14
Dr. John Wilson
NULL
NULL
NULL
NULL
NULL
NULL
NOL
Dr. Laura Miller
54
Ibuprofen
2 pills daily
2020-05-30 00:00:00.000 32
Laura Davis
Dr. Laura Moore
312
Aspirin
2 pills daily
2020-06-24 00:00:00.000 57
James Davis
Dr. Laura Moore
313
Amoxicillin
Dr. Laura Moore
314
Paraceta... 2 pills daily
Dr. Michael Brown 103
10
10
Dr. Michael John... 279
Dr.
Michael M
Moore 65
1 pill daily
Inject once a week 2020-06-24 00:00:00.000 57
2020-06-24 00:00:00.000 57
Omeprazole Take every 8 ho... 2020-06-24 00:00:00.000 29
Omeprazole 1 pill c
1 daily
2020-05-22 00:00:00.000 40
Metformin
2020-09-08 00:00:00.000 21
James Davis
James Davis
John Davis
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
29 4
Dr. Sarah Jones
298
30 4
Dr. Sarah Jones
299
31
19
Dr. Sarah Williams
NULL
Amoxicillin
Ibuprofen
NULL
Apply topically
Inject once a week
NULL
2020-07-23 00:00:00.000 50
2020-07-23 00:00:00.000 50
NULL
Laura Moore
NULL
Laura Moore
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
+ 100%
Close
