CBSE · 083Class XII · 2022Section A1 mark
Question 6b
7 June 2022 · Computer Science (083)
Table: DOCTOR
| DNO | DNAME | FEES |
|---|---|---|
| D1 | AMITABH | 1500 |
| D2 | ANIKET | 1000 |
| D3 | NIKHIL | 1500 |
| D4 | ANJANA | 1500 |
Table: PATIENT
| PNO | PNAME | ADMDATE | DNO |
|---|---|---|---|
| P1 | NOOR | 2021-12-25 | D1 |
| P2 | ANNIE | 2021-11-20 | D2 |
| P3 | PRAKASH | 2020-12-10 | NULL |
| P4 | HARMEET | 2019-12-20 | D1 |
Write the output of the SQL query: SELECT PNAME, ADMDATE, FEES FROM PATIENT P, DOCTOR D WHERE D.DNO = P.DNO AND FEES > 1000;
Answer
| PNAME | ADMDATE | FEES |
|---|---|---|
| NOOR | 2021-12-25 | 1500 |
| HARMEET | 2019-12-20 | 1500 |
Explanation
Joins the tables on DNO and filters for records where Fees are greater than 1000.