Carlos

COVID-19 Global Data Exploration Using SQL

This project involves in-depth data exploration of the COVID-19 pandemic using raw global data. Using SQL Server, I performed queries to analyze infection rates, death percentages, and population impact across countries and continents.

Skills & Tools: SQL Joins, CTEs, Temp Tables, Aggregate Functions, Window Functions, Views, Data Type Conversion

Key Insights:

• Calculated death percentage based on total cases vs. total deaths per country
• Determined infection percentage by comparing total cases against population
• Ranked countries by highest infection rate and death count
• Analyzed continent-level summaries to identify regions most affected
• Summarized global statistics, such as total cases, deaths, and death rate

Example Query - Death Percentage in the US:

    SELECT 
      Location, 
      Date, 
      Total_Cases, 
      Total_Deaths, 
      (Total    Total_Cases)    DeathPercentage
    FROM Portfoli   CovidDeaths
    WHERE Loca    '%states%'
    AND continent IS NOT NULL
    ORDER BY 1, 2;