can you just implement these queries given down below and give output
can you just implement these queries given down below and give output
|
CNIC |
Name |
Contact |
Dose1 Center |
Dose2 Center |
|
22401-6645321-1 |
Nasir |
3409991112 |
Lachi |
Kohat 2 |
|
14301-6045321-5 |
Shahab |
3409991112 |
kohat 3 |
Dara |
The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who were vaccinated ‘Sinovac’ in the first dose, while Pfizer in the second dose.
SELECT CNIC, Name, Contact, Dose1 Center,Dose2 Center
FROM Vaccination
WHERE Dose1 Name <> (SELECT Dose2 Name FROM Vaccination);
How many Viles of each type have been consumed so far.
SELECT Dose1 Name , COUNT(CNIC)
FROM Vaccination
GROUP BY Dose1 Name;
Suggest the name of Incharge for the best performance award based on the highest number of subjects vaccinated on a single day
SELECT name
FROM Vaccination
GROUP BY name
ORDER BY Count(Name) DESC
LIMIT 1;
Step by step
Solved in 2 steps with 3 images
