can you just implement these queries given down below and give output CNIC Name Contact Dose1 Center Dose2 Center XXXXXXXXXX Nasir XXXXXXXXXX Lachi Kohat 2 XXXXXXXXXX Shahab XXXXXXXXXX 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 thebest 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;