Skip to content

Files

Latest commit

 

History

History
14 lines (7 loc) · 786 Bytes

README.md

File metadata and controls

14 lines (7 loc) · 786 Bytes

Data-Analysis

This involves data mining, data aggregation and short analysis. These are all SQL based. SQL is a query language that allows to deal with big database and make quantitative analysis.

COVID-19 Deaths

Link to dataset - https://ourworldindata.org/covid-deaths

In this project, I have used SQL to do some Data Exploration on COVID-19 deaths dataset. I joined two tables named 'CovidDeaths' and 'CovidVaccinations'. Total cases vs total deaths, what percentage of population got covid in Bangladesh, likelihood of dying, countries with highest infection rate compared to population, used CTE, Temp Table and many other queries.

A short video of running the code.

Covid.sql.mp4