Work in Progress: Final write-ups and polish coming soon.
Last updated: Aug 28, 2025
Welcome to my personal repository for the 8 Week SQL Challenge. This repo contains my attempt at solving the SQL case studies designed by Danny Ma and contributors of the original challenge.
⚠️ Disclaimer: All credits for the case studies and datasets go to 8weeksqlchallenge.com. This repository only contains my personal solutions, which may contain errors or non-optimal approaches.
The 8 Week SQL Challenge is a hands-on learning project that improves SQL skills through practical case studies. Each case study presents a real-world business scenario requiring strong analytical thinking and SQL knowledge.
You can find the full challenge here (including the datasets used for each case):
https://8weeksqlchallenge.com/
- MySQL
- PostgreSQL
The SQL dialect used will also be indicated inside each solution folder.
- Case 1 – Danny's Diner
- Case 2 – Pizza Runner
- Case 3 – Foodie-Fi
- Case 4 – Data Bank
- Case 5 – Data Mart
- Case 6 – Clique Bait
- Case 7 – Balanced Tree
- Case 8 – Fresh Segments
- These are not official solutions.
- Solutions may contain mistakes or inefficiencies.
All case studies and datasets are created by:
Danny Ma
8 Week SQL Challenge
Data With Danny
All errors in this repository are my own.
If you spot any issues or have suggestions, feel free to open an issue or message me. I'm always learning and happy to improve.