Write SQL queries based on the table given below:

Table: HOSPITAL

S NO	Name	Age	Department	Datofadm	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	Ankita	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

(i) To list the names of all the patients admitted after 15/01/98.

(ii) To list the names of female patients who are in ENT department.

(iii) To list names of all patients with their date of admission.

(iv) To display Patient’s Name, Charges, Age for only female patients.

(i)

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

Output

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

(ii)

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

Output

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

(iii)

SELECT NAME, DATEOFADM FROM HOSPITAL;

Output

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

(iv)

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

Output

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