This repository contains all of my case study solutions through SQL queries for #8WeekSQLChallenge by Danny Ma.
This project uses the MySQL database management in writing SQL queries to solve these case studies.
There are 8 interesting real-world case studies in this challenge. You can also check out my solutions on Medium and Github via the link below.
| No | Case Study | SQL Topic Covered | Medium | GitHub | Status |
|---|---|---|---|---|---|
| 1 |  Danny's Diner |
Common Table Expressions (CTEs) / Group By Aggregates / Window Functions for Ranking / Table Joins | Link | Link | 🟢 Completed (04/05/2023) |
| 2 |  Pizza Runner |
Common Table Expressions (CTEs) / Group By Aggregates / Table Joins / String Transformations / Dealing with Null Values / Regular Expressions | - | - | 🟠 In Progress |
| 3 |  Foodie-Fi |
- | - | - | ⚪️ To Do |
| 4 |  Data Bank |
- | - | - | ⚪️ To Do |
| 5 |  Data Mart |
- | - | - | ⚪️ To Do |
| 6 |  Clique Bait |
- | - | - | ⚪️ To Do |
| 7 |  Balanced Tree Clothing Co. |
- | - | - | ⚪️ To Do |
| 8 |  Fresh Segments |
- | - | - | ⚪️ To Do |
Thank you so much for taking the time to visit my repository! 😁
You can also reach me at:
