In this case study, we will utilize data across 6 tables to perform fundamental operations that will aid in optimizing business operation. The tables include;
- runners table
- customer_orders table
- runner_orders table
- pizza_names table
- pizza_recipes table
- pizza_toppings table
The case study questions are broken up into 4 areas of focus including:
- Pizza Metrics
- Runner and Customer Experience
- Ingredient Optimizations
- Pricing and Ratings
Here is an article providing step-by-step guides on how to tackle the questions