This repository has the solutions for the 8 case studies from the #8WeekSQLChallenge by Data with Danny.
This project demonstrates my ability to solve diverse SQL challenges and apply strong query-writing and problem-solving skills. It reflects my proficiency in using SQL for analytical thinking and structured data exploration.
This challenge consists of 8 real-world inspired SQL case studies, each requiring different SQL techniques and analytical approaches. Each case study includes the problem statement, schema description, and SQL solutions with detailed explanations.
| Case Study | Topic | Status |
|---|---|---|
| Case Study #1 - Danny's Diner | Restaurant Customer Analysis | ✅ Complete |
| Case Study #2 | Pizza Runner | ⏳ In Progress |
| Case Study #3 | Foodie-Fi | ⏳ In Progress |
| Case Study #4 | Data Bank | ⏳ In Progress |
| Case Study #5 | Data Mart | ⏳ In Progress |
| Case Study #6 | Clique Bait | ⏳ In Progress |
| Case Study #7 | Balanced Tree | ⏳ In Progress |
| Case Study #8 | Fresh Segments | ⏳ In Progress |
- SQL Query Writing: SELECT, JOIN, GROUP BY, HAVING, WHERE, ORDER BY
- Data Aggregation: SUM, COUNT, AVG, MIN, MAX
- Window Functions: RANK, ROW_NUMBER, LEAD, LAG
- CTEs & Subqueries: Complex nested queries
- Data Cleaning: Handling NULL values, data type conversion
- Problem-Solving: Breaking down complex requirements into SQL solutions
- Database Design: Understanding schema relationships and normalization
Special thanks to Data with Danny for designing such insightful and engaging case studies that strengthen real-world SQL skills. 👋🏻
Last Updated: June 2026