This SQL script performs exploratory data analysis (EDA) on COVID-19 datasets (CovidDeaths and CovidVaccinations), calculating key metrics like infection rates, vaccination coverage, and mortality trends.
-
Global KPIs: Total cases, deaths, vaccination rates, and fatality rates.
-
Trend Analysis: Daily cases/deaths, vaccination rollouts, and case-fatality ratios.
-
Demographic Insights: Top countries by cases/deaths per million, healthcare correlations (e.g., hospital beds vs. deaths).
-
Vaccination Impact: Relationship between vaccination rates, human development index (HDI), and deaths.