Kizspy.me
Zoom
4 of 4
Paper No: 4
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
3
21
Dr. David Miller
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
11
Dr. Emma Johnson NULL
NULL
NULL
NULL
NULL
NULL
24
°
24
Dr. Emma Jones
NULL
NULL
NULL
NULL
NULL
NULL
13
15
Dr. Emma Jules
127
Omeprazole Inject once a week 2020-06-14 00:00:00.000 2
Sarah Johnson
10
13
Dr. Emma Jules
128
120
11
12 12
13
14
9
15
9
16
7
17
18
6
19
20
21
3
22
23 3
24
25
25
26
8
27
28
29
4
30
4
31
22222222
13
Dr. Emma Jules
129
Aspirin
Paraceta... Take every 8 ho...
Inject once a week
2020-06-14 00:00:00.000 2
Sarah Johnson
Dr. Emma
Dr. Emma Wilson
NULL
NOLL
NULL
NULL
25
Dr. James Brown
NULL
NULL
NULL
2020-06-14 00:00:00.000 2
NULL
NULL
Sarah Johnson
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
18
Dr. John Smith
NULL
NULL
NULL
NULL
NULL
NULL
Dr. John Taylor
NULL
NULL
NULL
NULL
NULL
NULL
14
Dr. John Wilson
NULL
NULL
NULL
NULL
NULL
NULL
23
Dr. Laura Miller
54
Ibuprofen
2 pills daily
Dr. Laura Moore
312
312
Aspirin
2 pills daily
Dr. Laura Moore
313
Dr. Laura Moore
314
Dr. Michael Brown 103
10
Dr. Michael John... 279
Dr. Michael Moore 65
Amoxicillin Inject once a week
Paraceta... 2 pills daily
Omeprazole Take every 8 ho...
Omeprazole 1 pill daily
Metformin
1 pill daily
17
Dr. Sarah Brown
NULL
NULL
NULL
20
Dr. Sarah Davis
NULL
NULL
NULL
2020-05-30 00:00:00.000 32
2020-06-24 00:00:00.000 57
2020-06-24 00:00:00.000 57
2020-06-24 0:00:00.000 57
2020-06-24 00:00:00.000 29
2020-05-22 00:00:00.000 40
2020-09-08 00:00:00.000 21
NULL
NULL
Laura Davis
James Davis
James Davis
James Davis
John Davis
Emily Taylor
Laura Smith
NULL
NULL
NULL
NULL
Dr. Sarah Jones
298
Amoxicillin
Apply topically
Dr. Sarah Jones
299
19
Dr. Sarah Williams NULL
Ibuprofen Inject once a week
NULL
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
AppointmentDate) of the doctor.
- FUO
+ 100%
Close
