8-Week-SQL-Challenge

This repository covers supplementary analysis and solutions of SQL for https://8weeksqlchallenge.com/ and classic interview questions, tradeoff between performance optimization and developmental efficiency. Executed via MySql environment.

Case Study #1 - Danny's Diner

Task Overview | Create Schema | Danny's Diner Solutions | Concept - case, aggregation, join, window functions, nested queries

Case Study #2 - Pizza Runner

Task Overview | Create Schema | Pizza Runner Solutions | Concept - case, aggregation, join, window functions, nested queries