Data Exploration with SQL

Start with selecting everything from CovidDeaths table. Order data by location and date

Looking at Covid19 Total Cases against Total Deaths. SELECT query returns the percentage of deaths form Covid19 in United Kingdom

Looking at Total Covid19 Cases against Population in United Kingdom between 2020-01-31 and 2021-07-18

Countries with highest Infection rates against Population

Countries with the highest death count per Population

Breaking down numbers by Continent

Continents with highest death count per Population grouped by Continent

Global Covid19 cases and deaths group by Date

Vaccination progress against Population. Include running number of vaccinated population per each country

Vaccination progress against Population. Showcasing use of Common Table Expression (CTE) to return pre-rendered results

Vaccination progress against Population. Store query results in Temporary table and then call temporary table to calculate Percentage of vaccinated population

Query Database and create View for reports and visualizations