COVID-19 SQL Data Analysis Project

📌 Project Overview

This project uses SQL to analyze a COVID-19 dataset and identify trends related to symptom severity, age-based risk, and COVID positivity rates. The goal is to demonstrate SQL querying skills using a healthcare-related dataset.

📂 Dataset

• Publicly available COVID dataset
• Each row represents an individual patient record

Key Columns:

• Age
• Fever (°F)
• Cough (Mild / Strong)
• Has_Covid (Yes / No)
• City

🛠 Tools & Technologies

• SQL (MySQL / PostgreSQL / SQLite)
• Git & GitHub

🔍 Key Analysis Performed

• Percentage of COVID-positive patients with fever ≥ 101°F
• Comparison of positivity rates between high-risk and low-risk patients
• Age group analysis by decade
• City-wise COVID-positive case distribution
• Symptom severity impact on COVID positivity

🧠 Sample SQL Queries

-- Identify high-risk patients
SELECT COUNT(*)
FROM covid_dataset
WHERE Age >= 60
  AND Fever >= 101
  AND Cough = 'Strong';