☑Kizspy.me
31 19
Dr. Sarah Williams NULL
NULL
NULL
NULL
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
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
12
Dr. Emma Wilson
Neurology 2
524.85
4
16
Dr. Chris Taylor
Neurology 1
114.29
5
17
Dr. Sarah Brown
Neurology 1
94.43
6
20
Dr. Sarah Davis
Neurology 2
240.54
7
23
Dr. Laura Miller
Neurology 0
0.00
8
24
Dr. Emma Jones
Neurology 3
918.17
9
25
Dr. James Brown
Neurology 4
Picture 5.1
1569.95
Question 6:
Zoom
- FUO
+ 100%
Close
