Problem
Write a SQL query using window functions to calculate a 7-day rolling average of daily orders by store.
Practicing as: Data Scientist interview at McDonald'sHi, I'll play your McDonald's interviewer for the Data Scientist role. Answer the question above like we're in the room, and I'll respond the way a real interviewer would.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.
