Window Functions
Talk it through with a coach who asks guiding questions and gives hints until you reach the answer. Pass to mark the challenge as completed.
The problem
- hard
- Pro
You need each customer's three most recent orders, and a running total of revenue by day. Explain what window functions are, how they differ from group by, and how you'd use them for both tasks.
Talk this problem through with an AI coach
This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.