--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:
No comments:
Post a Comment