Page 106 - IPP-12-2024

(i) Select count(distinct charges) FROM Hospital;

count(distinct charges)
3

(ii) Select MIN(Age) From Hospital WHERE Sex='M';

MIN(Age)

450

(iii) Select AVG(Charges) FROM Hospital where DateofAdm <
’1998-02-12’;

AVG(Charges)

387.5

(iv) Select SUM(Charges) FROM Hospital where Sex =’F’;

SUM(Charges)

1600

(v) Select Name FROM Hospital where Department IN (‘ENT’,
’Orthopedic’);

Name

Ravina

Karan

Zubina

Ketaki

(vi) Select LCASE(Department) FROM Hospital where Department Like ‘%y’;

LCASE(Department)

surgery
cardiology

gynecology