Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 92 of 103

Review of Database Concepts & SQL — Question 41

Back to all questions
41
Question

Question 28

Write SQL queries based on the table given below:

Table: HOSPITAL

S NONameAgeDepartmentDatofadmChargesSex
1Arpit62Surgery1998-01-21300M
2Zareena22ENT1997-12-12250F
3Kareem32Orthopaedic1998-02-19200M
4Arun12Surgery1998-01-11300M
5Zubin30ENT1998-01-12250M
6Ketaki16ENT1998-02-24250F
7Ankita29Cardiology1998-02-20800F
8Zareen45Gynaecology1998-02-22300F
9Kush19Cardiology1998-01-13800M
10Shilpa23Nuclear Medicine1998-02-21400F

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

Answer

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