Answer the questions based on the table given below:

Table: HOSPITAL

S.No.	Name	Age	Department	Dateofadm	Charges	Sex
1	Arpit	62	Surgery	1998-01-21	300	M
2	Zareena	22	ENT	1997-12-12	250	F
3	Kareem	32	Orthopaedic	1998-02-19	200	M
4	Arun	12	Surgery	1998-01-11	300	M
5	Zubin	30	ENT	1998-01-12	250	M
6	Ketaki	16	ENT	1998-02-24	250	F
7	Ankit	29	Cardiology	1998-02-20	800	F
8	Zareen	45	Gynaecology	1998-02-22	300	F
9	Kush	19	Cardiology	1998-01-13	800	M
10	Shilpa	23	Nuclear Medicine	1998-02-21	400	F

(a) To list the names of all the patients admitted after 1998-01-15.

(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:

1. SELECT COUNT(DISTINCT Charges) FROM HOSPITAL;
2. SELECT MIN(Age) FROM HOSPITAL WHERE Sex = "F";

(a)

SELECT NAME
FROM HOSPITAL
WHERE DATEOFADM > '1998-01-15';

+--------+
| NAME   |
+--------+
| Arpit  |
| Kareem |
| Ketaki |
| Ankit  |
| Zareen |
| Shilpa |
+--------+

(b)

SELECT NAME
FROM HOSPITAL
WHERE SEX = 'F' AND DEPARTMENT = 'ENT';

+---------+
| NAME    |
+---------+
| Zareena |
| Ketaki  |
+---------+

(c)

SELECT NAME, DATEOFADM
FROM HOSPITAL
ORDER BY DATEOFADM;

+---------+------------+
| NAME    | DATEOFADM  |
+---------+------------+
| Zareena | 1997-12-12 |
| Arun    | 1998-01-11 |
| Zubin   | 1998-01-12 |
| Kush    | 1998-01-13 |
| Arpit   | 1998-01-21 |
| Kareem  | 1998-02-19 |
| Ankit   | 1998-02-20 |
| Shilpa  | 1998-02-21 |
| Zareen  | 1998-02-22 |
| Ketaki  | 1998-02-24 |
+---------+------------+

(d)

SELECT NAME, CHARGES, AGE
FROM HOSPITAL
WHERE SEX = 'F';

+---------+---------+-----+
| NAME    | CHARGES | AGE |
+---------+---------+-----+
| Zareena |     250 |  22 |
| Ketaki  |     250 |  16 |
| Ankit   |     800 |  29 |
| Zareen  |     300 |  45 |
| Shilpa  |     400 |  23 |
+---------+---------+-----+

(e)

1. SELECT COUNT(DISTINCT Charges) FROM HOSPITAL;

+-------------------------+
| COUNT(DISTINCT Charges) |
+-------------------------+
|                       5 |
+-------------------------+

2. SELECT MIN(Age) FROM HOSPITAL WHERE Sex = "F";

+----------+
| MIN(Age) |
+----------+
|       16 |
+----------+