I have this SQL Query to retrieve data in date range
SELECT v.date AS Observation_Month,
SUM(CASE WHEN v.location_id = 213 THEN v.people_vaccinated END) AS United_States,
SUM(CASE WHEN v.location_id = 219 THEN v.people_vaccinated END) AS Wales,
SUM(CASE WHEN v.location_id = 36 THEN v.people_vaccinated END) AS Canada,
SUM(CASE WHEN v.location_id = 55 THEN v.people_vaccinated END) AS Denmark
From vaccinations v where `date` >= '01-01-2022' and `date` <= '31-12-2023'
GROUP BY date;
the result as below
i try another query
SELECT v.date AS Observation_Month,
SUM(CASE WHEN v.location_id = 213 THEN v.people_vaccinated END) AS United_States,
SUM(CASE WHEN v.location_id = 219 THEN v.people_vaccinated END) AS Wales,
SUM(CASE WHEN v.location_id = 36 THEN v.people_vaccinated END) AS Canada,
SUM(CASE WHEN v.location_id = 55 THEN v.people_vaccinated END) AS Denmark
From vaccinations v where `date` between '01-01-2022' and '31-12-2023'
GROUP BY date
but the result same as first code
Any Idea please?