SQL queries for the 8-Week SQL Challenge created by Data with Danny.
| Case Study | Description | Questions and SQL Queries |
|---|---|---|
| #1 - Danny's Diner | Helping a small restaurant use data to answer business questions | Case Study Questions |
| #2 - Pizza Runner | Using data to improve operations at a pizza delivery service | |
| #3 - Foodie-Fi | Understanding customer trends at a startup providing exclusive on-demand cooking shows |
Data for each case study is stored in their own schema in a local PostgreSQL database.
Schema and tables for each case study are created using the SQL code provided in the case study webpage (refer to the sections named Interactive SQL Session). A copy of each schema's SQL codew is stored in this repository for reference:
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent