as4c / sql-covid-19-data-analysis

SQL COVID-19 Data Analysis Project

This project involves analyzing COVID-19 data from two tables: CovidDeath and covidVaccinationDb in the database MyDb. The goal is to gain insights into infection rates, death rates, vaccination progress, and other related metrics.

Table Contents

1. Data Selection
2. Total Cases vs Total Deaths
3. Total Cases vs Population
4. Countries with Highest Infection Rate
5. Countries with Highest Death Count per Population
6. Continent with Highest Death Count
7. Global Numbers
8. Total Population vs Vaccinations
9. Using CTE to Perform Calculation
10. Using Temp Table to Perform Calculation
11. Creating View for Data Storage