29
4
Dr. Sarah Jones
298
Kizspy.me 30 4
Dr. Sarah Jones
299
31
19
Dr. Sarah Williams NULL
Amoxicillin
Ibuprofen
NULL
Apply topically
2020-07-23 00:00:00.000 50
Inject once a week 2020-07-23 00:00:00.000 50
NULL
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.
- SumOfBilling TotalAmount is the sum of TotalAmount of all billings for appointments in 2021
and 2022 (based on AppointmentDate) of the doctor.
Note that the NumberOfAppointments = 0 and SumOfBilling TotalAmount = 0 if the doctor
has no appointment with the AppointmentDate in 2021 or 2022.
DoctorID FullName
Specialty NumberOfAppointments SumOfBilling TotalAmount
1
3
Dr. Laura Moore
Neurology 0
0.00
2
10
Dr. Michael Johnson
Neurology 2
422.34
3
4
5
6
7
8
9
2672222
12
Dr. Emma Wilson
Neurology 2
524.85
16
Dr. Chris Taylor
Neurology 1
114.29
17
Dr. Sarah Brown
Neurology 1
94.43
20
Dr. Sarah Davis
Neurology 2
23
Dr. Laura Miller
Neurology 0
24
Dr. Emma Jones
Neurology 3
25
Dr. James Brown
Neurology 4
Picture 5.1
240.54
0.00
918.17
1569.95
Question 6:
Zoom
- FUO
+ 100%
Close
