Question

Write the output of SQL queries (a) to (d) based on the table VACCINATION_DATA given below:

                              Table: VACCINATION_DATA

VID	Name	Age	Dose1	Dose2	City
101	Jenny	27	2021-12-25	2022-01-31	Delhi
102	Harjot	55	2021-07-1 4	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

1. SELECT Name, Age FROM VACCINATION_DATA
WHERE Dose2 IS NOT NULL AND Age > 40;
2. SELECT City, COUNT(*) FROM VACCINATION_DATA GROUP BY City;
3. SELECT DISTINCT City FROM VACCINATI ON_ DATA;
4. SELECT MAX(Dose1), MIN(Dose2) FROM VACCINATION_ DATA;

Answer 1

Full coding is given as follows:

(a)

Name	Age
Harjot	55
Srikanth	43

(b) 

City	COUNT(*)
Delhi	2
Kolkata	1
Mumbai	2

(c) 

CITY

Delhi

Mumbai

Kolkata

(d) 

MAX(Dose1)	MIN(Dose2)
2022-01-01	2021-01-20