Explain what SQL window functions are and how they differ from regular aggregate functions. Give an example of how you would use ROW_NUMBER or RANK in a BI report.

Sample answer preview

Window functions perform calculations across a set of rows that are related to the current row, without collapsing the result set into groups. This is the key difference from regular aggregate functions, which reduce multiple rows into a single summary row per group.