Write a SQL query using window functions to calculate each customer's 7-day rolling average order value.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.