9
25
Dr. James Brown
Kizspy.me
Neurology 4
1569.95
Picture 5.1
Question 6:
5 of 5
Paper No: 4
Write a query to identify, for each Specialty, doctors who have the highest sum of total billing
amount from appointments. The results must include Specialty, DoctorID, FullName,
SumOfTotalAmount, where the SumOfTotalAmount of each doctor is the sum of
TotalAmount of all billings from appointments of the doctor. Order the results by ascending
order of Specialty, then by ascending order of DoctorID for rows of the same Specialty as
follows:
Specialty
12345678
DoctorID FullName
SumOfTotalAmount
Cardiology
8
Dr. Michael Moore
1272.83
Dermatology
2
Dr. David Taylor
3656.38
General Surgery 4
Dr. Sarah Jones
1307.37
Neurology
23
Dr. Laura Miller
2591.39
Ophthalmology
13
Dr. Emma Jules
3882.68
Orthopedics
6
Dr. John Taylor
2440.93
Pediatrics
15
Dr. Emily Williams 2228.79
Psychiatry
14
Dr. John Wilson
1539.12
Picture 6.1
Zoom
- FUO
Question 7:
Write a query to display the most common diagnoses given by each doctor with the
+ 100%
Close
