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

3

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

The solution given appears to have a problem. According to the solution Customer A got 1020 points and Customer B got 320. I wasn't able to fully figure out where...

A-C-Sai

Hi Katie, Thank you so much for uploading the solutions and explaining them aptly. To my understanding, in this solution, **next_date should be 'not null.'** ( your query says -...

Rishi280206

`4. What is the most purchased item on the menu and how many times was it purchased by all customers?` For the question above in Case Study#1 - Danny's Diner,...

FisherKob