☑Kizspy.me
have no appointment in this period. Display the results with DoctorID, DoctorFullName,
AppointmentID, AppointmentDate, TotalAmount, PaidAmount where TotalAmount and
PaidAmount are the amounts of the billing corresponding to each appointment. Order the
result in descending order of DoctorFullName, then in ascending order of TotalAmount for
appointments of the same doctor as in the following figure:
Zoom
4 of 4
Paper No: 9
DoctorID DoctorFullName
1
19
Dr. Sarah Williams
AppointmentID AppointmentDate
NULL
TotalAmount PaidAmount
NULL
NULL
NULL
2
4
Dr. Sarah Jones
40
3
20
Dr. Sarah Davis
154
4
20
Dr. Sarah Davis
65
2021-05-25 00:00:00.000 53.38
2021-05-19 00:00:00.000 59.17
2021-04-09 00:00:00.000 181.37
2.88
41.56
38.98
5
17
Dr. Sarah Brown
6
8
Dr. Michael Moore
NULL
30
NULL
NULL
NULL
2021-08-02 00:00:00.000 363.19
36.08
7
10
Dr. Michael Johnson 16
2021-03-01 00:00:00.000 102.03
64.26
Close
+119%
