SumOfBilling TotalAmount for all doctors having the specialty 'Neurology'; where, for each
✓ Kizspy.me 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.
Specialty NumberOfAppointments SumOfBilling TotalAmount
DoctorID FullName
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
9
25
Dr. Emma Jones
Dr. James Brown
Neurology 3
Neurology 4
918.17
1569.95
Picture 5.1
Question 6:
Zoom
+ 100%
Close
