Your goal: pick the right window function for rankings, change over time
and running totals, and explain how it treats ties.
How this works (about 20 minutes)
- Maya's live board shows two small tables: player scores and daily orders.
- You tap your prediction first, then the rows appear and the window frame walks through them.
- Four times you write a query yourself in the board's editor and tap Run. Matching rows turn green; missing rows show as ghosts.
- Three quick checks, all about ties: tap your answer on the board.
Tips
- Before writing OVER, say the partition and the order out loud.
- Any SQL dialect is fine. Rough syntax is fine; the logic matters.
- Read the module reading first: SQL Window Functions.
- Interrupt any time to ask a question.