sql queries

SELECT
ockovaci_mista.misto_id,
ockovaci_mista.misto_nazev,
ockovani.vekova_skupina,

COUNT(*) as total,
COUNT(CASE WHEN ockovani.vakcina = "Comirnaty" THEN 1 ELSE null END) as pfizer,
COUNT(CASE WHEN ockovani.vakcina = "Comirnaty" OR ockovani.vakcina = "COVID-19 Vaccine Moderna" THEN 1 ELSE null END) as mrna,
COUNT(CASE WHEN ockovani.vakcina = "COVID-19 Vaccine Moderna" THEN 1 ELSE null END) as moderna,
COUNT(CASE WHEN ockovani.vakcina = "COVID-19 Vaccine AstraZeneca" THEN 1 ELSE null END) as astrazeneca

FROM `ockovani`
JOIN ockovaci_mista ON ockovaci_mista.nrpzs_kod = ockovani.misto_kod
WHERE ockovani.datum > (SELECT MAX(datum) from ockovani) - INTERVAL 8 DAY
GROUP BY ockovaci_mista.misto_id, ockovaci_mista.misto_nazev, ockovani.vekova_skupina




SELECT

misto_id,
misto_nazev,
vekova_skupina,
povolani,
rezervace,
AVG(datum_rezervace - datum) as average_wait_time,
COUNT(*) as total


FROM `registrace`
WHERE datum > ((SELECT MAX(datum) FROM registrace) - INTERVAL 8 DAY)
GROUP BY misto_id, misto_nazev, vekova_skupina, povolani, rezervace