← Learn/Part 3 · Advanced queries and reports

Window functions are the superpower of analytics: aggregates that don't collapse the rows. Product rankings, running sales totals, order-to-order dynamics, top-N in each category — it's all here. The key idea: OVER computes over a "window" of rows, but each row stays in the answer.