📚 100 Days SQL Challenge

DAY 12

🔧 Complete Data Cleaning Pipeline

E-Commerce messy data cleaning with REGEXP validation, multi-table JOINs, and data quality scoring.

Data Cleaning JOINs REGEXP Quality

DAY 13

💳 Banking Fraud Detection

Build a fraud detection pipeline with window functions, risk scoring, and multi-table JOINs for banking security.

Window Functions Fraud Detection Risk Scoring LAG/TIMESTAMPDIFF

DAY 14

🏥 Hospital Patient Management

Track patient records, prescriptions, and medications with data cleaning, JOINs, date calculations, and risk scoring.

Healthcare Data Prescription Tracking Date Calculations Risk Scoring

DAY 15

🏛️ Government Welfare & Subsidy Management

Validate subsidies, detect fraud, and manage citizen benefits with multi-table JOINs.

BETWEEN Fraud Detection CTEs Multi-Table JOINs

DAY 16

🎬 Netflix Movies Analytics Platform

Analyze movies with window functions, rankings, percentiles, and complex multi-table JOINs.

Window Functions RANK & PARTITION BY CTEs Percentiles

DAY 17

🚗 Ride-Sharing Trip Analytics

Build analytics with surge pricing, cancellations, and driver performance metrics.

Window Functions RANK & PARTITION BY TIMESTAMPDIFF CTEs

DAY 18

🍕 Food Delivery Order Lifecycle Analysis

Track orders from placement to delivery with lifecycle analytics and rider performance metrics.

Order Lifecycle TIMESTAMPDIFF Window Functions Complex JOINs

DAY 19

✈️ Airline Flight Delays & Aircraft Utilization

Analyze flight delays, aircraft performance, and maintenance tracking for airline operations

TIMESTAMPDIFF DATEDIFF Performance Metrics CTEs

DAY 20

🏨 Hotel Booking & Occupancy Trends

Analyze hotel data with JOINs, calculate revenue, and track guest patterns

INNER JOIN DATEDIFF Data Cleaning Aggregations

DAY 21

📦 Amazon Subscription Churn & Renewal Analysis

Analyze subscription data, track churn, detect at-risk users, and calculate MRR

Multi-Table JOINs Churn Analysis CTEs Risk Segmentation

DAY 22

📞 BSNL Telecom Call Detail Records Analysis

Analyze CDR data with self-joins, calculate revenue, detect fraud patterns

Self-JOINs Time Functions Revenue Calculation Fraud Detection