This repository contains the solutions to the case studies in 8WeekSQLChallenge created by Danny Ma
Each case-study folder contains the following files
- SQL file to create the schema, tables and loading data
- A readme file explaining the problem statement, ERD, and case study questions
- A jupyter notebook which contains SQL queries answering the respective challenge questions
PS; I used various SQL dialect and db throughout each case study to challenge myself. The dialect and db used will be documented in the readme of each case study.
- 🍜Case Study #1 - Danny's Diner
- 🍕Case Study #2 - Pizza Runner
- 🥑Case Study #3 - Foodie-Fi
- Case Study #4 - Data Bank