Posts

Showing posts with the label Restaurant Growth 7 Days Sales Average Problem Description –

Restaurant Growth 7 Days Sales Average Problem Description

Image
 --Restaurant Growth 7 Days Sales Average Problem Description – --You are the restaurant owner and you want to analyze a possible expansion (there will be at least one customer every day). --Write an SQL query to compute the moving average of how much the customer paid in a seven days window  --(i.e., current day + 6 days before) --Return result table ordered by visited_on in ascending order. Check out my solution on Youtube: Click here to download the SQL SCRIPT: