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.

Start free →