CBSE Class 12 Computer Science
Question 79 of 91
Relational Database and SQL — Question 40
Back to all questions 40
Question 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:
- SELECT COUNT(DISTINCT Charges) FROM HOSPITAL;
- 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 |
+----------+