andriibaranets/8-Week-SQL-Challenge

Case study solutions for #8WeekSQLChallenge at https://8weeksqlchallenge.com

8-Week-SQL-Challenge

Case study solutions for #8WeekSQLChallenge at https://8weeksqlchallenge.com

---

Case Study #1 - Danny's Diner

SQL Functions used - Temporary tables, Aggregations, Joins, CTEs, Window functions

• Business case
• Solution

---

Case Study #2 - Pizza Runner

SQL Functions used - Temporary tables, Aggregations, Joins, CTEs, Window functions, Regular Expressions, Arrays

• Business Case
• Solution A
• Solution B
• Solution C
• Solution D
• Solution E
• Database setup
• Data Cleanup