@rennerocha

SQL window functions are powerful and amazing.

In SQL Server, even the 'traditional' aggregate functions (MIN, MAX, AVG, COUNT) can be used as window functions.