The fourth challenge in the Summer of SQL Challenge is taken from the 8 Week SQL Challenge, case study #2 Pizza Runner.

Sharing my solutions via Git Hub as three separate links as there were three distinct sections:

Part A: Pizza Metrics

Part B: Runner and Customer Experience

Part C: Ingredient Optimization

I created a database, added the tables, and did the analysis using Microsoft SQL Server. On part C the LATERAL SPLIT_TO_TABLE and STRING_SPLIT functions were unavailable to me so I used recursive CTEs instead.

Details on the Summer of SQL Challenge can be found here: https://github.com/wjsutton/the_summer_of_sql