Welcome to the 8 Week SQL Challenge solutions repository! This repository contains my personal solutions to the popular SQL case studies created by Danny Ma. Each case study has been tackled in detail, providing solutions that are easy to understand and implement, even for beginners.
The 8 Week SQL Challenge is a set of eight case studies designed to help individuals strengthen their SQL skills by solving real-world problems. These case studies cover a wide range of business scenarios, allowing you to practice writing complex queries while applying SQL concepts like joins, window functions, subqueries, and more.
This repository is organized into eight folders, each corresponding to a specific case study from the challenge:
-
Case Study #1: Danny's Diner
Focus: Simple aggregations, joins, and date-based filtering. -
Case Study #2: Pizza Runner
Focus: Handling NULL values, data cleaning, and filtering. -
Case Study #3: Foodie-Fi
Focus: Subscription-based data analysis, window functions. -
Case Study #4: Data Bank
Focus: Customer segmentation, advanced filtering, and ranking. -
Case Study #5: Data Mart
Focus: CTEs, window functions, and rolling aggregations. -
Case Study #6: Clique Bait
Focus: Marketing campaign analysis, funnel conversion. -
Case Study #7: Balanced Tree
Focus: Financial performance and stock trading. -
Case Study #8: Fresh Segments
Focus: Customer behavior and market segmentation.
Each folder contains SQL scripts for the solutions, along with detailed explanations and the thought process behind each query.
-
Navigate to the folder of the case study you are interested in.
-
Review the SQL scripts provided for each question in the case study.
-
Use these scripts to solve the problems in your own environment.
Note: All Solutions are Coded with MySQL
Feel free to download, modify, or adapt the solutions to fit your learning needs. Contributions and feedback are welcome!
- Visit the official 8 Week SQL Challenge website for the full case study descriptions.
- Watch my YouTube series, Danny's SQL Challenge Solutions, where I walk through each case study with explanations.
I’m Vaibhav Chavan, the creator of iThinkData, a platform dedicated to making data analytics and SQL easy to understand for everyone. Follow along as I dive deep into SQL tutorials, case studies, and data projects on YouTube.
🌟 Stay Connected with iThinkData ! 🌟
🎥 Subscribe to iThinkData : 🔔 Don't miss out on weekly data challenges, tutorials, and expert insights! 💡📈
👨💼 LinkedIn : 📊 Let’s connect professionally and build a powerful data-driven network! 💼🌐
💬 Join My WhatsApp Channel : 📱 Be the first to get exclusive content, project updates, and new videos! 🚀📊