📊 8-Week SQL Challenge

This repository contains my solutions to the 8 Week SQL Challenge by Data With Danny.

The goal of this project is to strengthen SQL fundamentals through real-world case studies and develop strong problem-solving patterns.

---

🧠 Skills Demonstrated

• Joins
• Aggregations
• Window Functions
• Case Statements
• Subqueries

---

📁 Repository Structure

Each case study contains:

• schema.sql → table creation and sample data
• questions.md → problem statements
• solutions.sql → clean and final SQL queries
• explanations.md → approach, patterns, and key learnings

---

📚 Case Studies

• Case Study #1: Danny's Diner
• Case Study #2: Pizza Runner
• Case Study #3: Foodie-Fi
• Case Study #4: Data Bank
• Case Study #5: Data Mart
• Case Study #6: Clique Bait
• Case Study #7: Balanced Tree
• Case Study #8: Fresh Segments

---

💡 Learning Approach

Instead of only focusing on final answers, this repository emphasizes:

• Understanding SQL patterns
• Writing clean and readable queries
• Handling edge cases

---

🙌 Acknowledgement

Special thanks to Data With Danny for creating these insightful SQL case studies.

---

📌 Note

This repository is intended for learning and reference.
If you're working through the challenge, try solving the questions yourself before checking the solutions.

---

🔗 Connect With Me

• LinkedIn

---

— Vivek