This is a dataset I downloaded from Kaggle Worldwide Covid Cases & Vaccination Data Combined (https://www.kaggle.com/datasets/kunwarakash/covid-cases-and-vaccination-data)
Here are some of the questions I tried to answer based on the dataset:
- Which are the top 5 countries with the highest number of fully vaccinated people?
SELECT country, SUM(fully_vaccinated) AS vaccine_totals
FROM covid
GROUP BY country
ORDER BY vaccine_totals DESC
LIMIT 5;
- What are the average total reported deaths from Covid-19 per country?
SELECT country, AVG(total_deaths) as death_avg
FROM covid
GROUP BY country
ORDER BY country;
- What are the totals of reported Covid-19 cases and Covid-19 deaths in every country?
SELECT country, SUM(total_cases) AS cases, SUM(total_deaths) AS deaths
FROM covid
GROUP BY country;
- How many covid cases and covid deaths were reported between 01-22-2020 and 02-22-2020 per country?
SELECT distinct(country), date, daily_deaths, daily_cases
FROM covid
WHERE date between '2020-01-22' AND '2020-02-22'
AND daily_deaths > 0
ORDER BY date ASC;
- When was the first Covid-19 case reported in Suriname?
SELECT country, date, daily_cases
FROM covid
WHERE country = 'suriname'
AND daily_cases >0
ORDER BY date
