Page 117 - IPP-12-2025
P. 117
(vii) Select department, sum(charges), max(charges) from hospital
group by department;
department sum(charges) max(charges)
Surgery 600 300
Orthopedic 400 200
ENT 550 300
Cardiology 1600 800
Gynecology 300 300
Medicine 400 400
Program 24: SQL queries based on the following two tables—Activity,
Coach:
(a) Display the names of all the activities with their Codes in descending order.
