This project is the 2nd case study in 8 Week SQL Challenge by Danny Ma (link at the end). The Database contains data related to the sales of a pizza delivery service called Pizza Runner. We have queried database for Pizza Metrics, Runner and Customer Experience, Ingredient Optimization etc. The schema of database is as follows:
The files in this repository are as follows:
PR Database Creation.sql is the code for creating database schema and inserting values.
Pizza Runner Solutions.sql contains questions regarding sales of restaurant and SQL queries to answer them.
PR DB Mindmap.jpg is a mindmap of tables and columns in the database created in MindMaster software.
Details about this case study: https://8weeksqlchallenge.com/case-study-2/
Homepage of 8 Week SQL challenge: https://8weeksqlchallenge.com/getting-started/