☑Kizspy.me
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
Zoom
DoctorID
FullName
SumOfTotalAmount
12345678
Cardiology
8
Dr. Michael Moore
1272.83
Dermatology
2
Dr. David Taylor
3656.38
3
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
Question 7:
Write a query to display the most common diagnoses given by each doctor with the
corresponding distinct patients that the doctor has diagnosed with each most common
diagnosis. The results must include DoctorID, DoctorFullName, Diagnosis, PatientID,
PatientFullName; where Diagnosis is the most common diagnosis given by the doctor,
+119%
Close
