1. How do window functions differ from standard GROUP BY aggregations?
- Window functions execute faster than GROUP BY.
- Window functions perform aggregates across related rows without collapsing the result set (preserving original rows).
- Window functions do not support SUM or AVG.
- Window functions can only run on indexed columns.
Hint: Standard GROUP BY collapses rows into a single summary row. Window functions calculate aggregates over a group (window) of rows but return one output row per input row.