CBSE · 083Class XII · 2022Section A1 mark
Question 5a
7 June 2022 · Computer Science (083)
Table: VACCINATION_DATA
| VID | Name | Age | Dose1 | Dose2 | City |
|---|---|---|---|---|---|
| 101 | Jenny | 27 | 2021-12-25 | 2022-01-31 | Delhi |
| 102 | Harjot | 55 | 2021-07-14 | 2021-10-14 | Mumbai |
| 103 | Srikanth | 43 | 2021-04-18 | 2021-07-20 | Delhi |
| 104 | Gazala | 75 | 2021-07-31 | NULL | Kolkata |
| 105 | Shiksha | 32 | 2022-01-01 | NULL | Mumbai |
Write the output of the SQL query: SELECT Name, Age FROM VACCINATION_DATA WHERE Dose2 IS NOT NULL AND Age > 40;
Answer
| Name | Age |
|---|---|
| Harjot | 55 |
| Srikanth | 43 |
Explanation
Selects records where Dose2 is not null and Age is greater than 40.