aroinsights / sql-data-exploration Goto Github PK

Global COVID-19 Deaths: Data Exploration

Explore the global data on confirmed COVID-19 deaths between 24 Feb 2020 and 16 December 2022

Data source: Our World in Data COVID-19 dataset

Performed the following tasks:

• Starting with location, date, total_cases, new_cases, total_deaths, population
• Total Cases vs Total Deaths in the United Kingdom
• Total Cases vs Population in the United Kingdom
• Countries with Highest Infection Rate compared to Population
• Countries with Highest Death Count per Population
• Using CTE to perform Calculation on Partition By in previous query
• Comparison between Total population and Covid Vaccinations
• Using Temp Table to perform Calculation on Partition By in previous query
• Creating View to store data for later visualizations