Page 116 - PYTHON-12
P. 116
(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
4: SQL queries based on the following two tables—Activity, Coach:
(a) Display the names of all the activities with their Codes in descending order.
