Coronavirus (COVID-19) Data Exploration using SQL

Number of rows 339,462 in table of Covid Deaths
Number of rows 339,562 in table of Covid Vaccinations
Initial Data of Covid Deaths

Initial Data of Covid Vaccinations

Select Location, date, total_cases, new_cases, total_deaths, population

total case vs total deaths % in Canada

total case vs total deaths % in Canada

total case vs total population % in Canada

Countries with highest infection rate %

Countries with highest death

Datewise global total cases, deaths & deathrate
Datewise addition of total cases & deaths across the globe. And also death vs case %.

Global total number: total cases, total deaths and death %

Countrywise Rolling People Vaccinated
Total number of vaccinated people added each day/ datewise in a particular country

Total population vs Rolling People Vaccinated %

Creating view to store data for visualization
