Using GROUP BY when window function needed

Use aggregate with OVER to keep all rows

GROUP BY collapses rows. Window functions keep all rows.

Use window functions to preserve rows

Medium

Rows collapsed