8-week SQL Challenge - Overview

SQL queries for the 8-Week SQL Challenge created by Data with Danny.

Case Studies

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	Data Pre-processing Part A - Pizza Metrics Part B - Runner and Customer Experience Part C - Ingredient Optimization Part D - Pricings & Rating
#3 - Foodie-Fi	Understanding customer trends at a startup providing exclusive on-demand cooking shows	Part A - Customer Journey Part B - Data Analysis

Setup

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:

• Case Study 1 Schema
• Case Study 2 Schema
• Case Study 3 Schema