8-Week-SQL-Challenge

8-Week-SQL-Challenge copied to clipboard

There is no solution provided for the below question under "Ingredient Optimizations" for the Pizza Runner Case Study. 1. What are the standard ingredients for each pizza?

Ritwik-Gupta

Data Mart : Part C before and after analysis

5

Using the week_number to filter out the dates would result in incorrect analysis. A simple query will show that week_number shift in 2020.  Hence it is better to use...

praveen555

.

manvideore21

Pizza Runner A 10

2

I think your code was wrong, simply look up 01/01/2020 was Wednesday and your result doesn't have it.

dannytheanalyst911

captainatul

I think the question is asking about the average time for each customer , so it should be grouped by runner_id. Please look into it once

captainatul

captainatul