Related Project >>> Covid 19 Dashboard with Tableau
This Covid-19 data exploration project utilizes SQL skills, including joins, CTE’s, Temp Tables, and window functions, to analyze global pandemic data.
It examines mortality rates, vaccination coverage, and infection patterns.
Developed under the guidance of Alex Freberg, this project provides practical insights into data exploration using SQL Server.
The datasets were gathered from Our World in Data. We can also download it through this link.
Total Cases vs Total Deaths in Indonesia
We explored daily total cases and total death due to Covid-19 from March 2020 to April 2021.
SELECT countries, date, total_cases, total_deaths, ROUND((total_deaths/total_cases)*100, 2) as death_percentage
FROM PortfolioProject..CovidDeath
where countries = 'indonesia' and continent is not null
ORDER by 2
Daily Vaccination Given of Each Countries
SELECT dea.continent, dea.countries, dea.date, dea.population, vac.new_vaccinations
, SUM(CONVERT(int, vac.new_vaccinations)) OVER (PARTITION BY dea.countries ORDER BY dea.countries, dea.date) as daily_count_vaccinations
FROM PortfolioProject..CovidDeath dea
JOIN PortfolioProject..CovidVac vac
ON dea.countries = vac.countries AND dea.date = vac.date
WHERE dea.continent is not null
ORDER BY 2, 3
