☑Kizspy.me
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.
Zoom
+119%
Close
