Page 301 - PYTHON-12

6 Ketaki 16 ENT 24-02-98 250 F
7 Ankit 29 Cardiology 20-02-98 800 F
8 Zareen 45 Gynecology 22-02-98 300 F
9 Kush 19 Cardiology 13-01-98 800 M
10 Shilpa 23 Nuclear Medicine 21-02-98 400 F
(a) To list the names all the patients admitted after 15/01/98.
(b) To list the names of female patients who are in ENT department.
(c) To list the names of all patients with their date of admission in ascending order.
(d) To display Patient’s Name, Charges, Age for only female patients.
(e) Find out the output of the following SQL commands:-
(i) Select COUNT(DISTINCT charges) from HOSPITAL;
(ii) Select MIN(Age) from HOSPITAL where Sex=”F”;

Relational Database and SQL

12.71