SQL window functions: what separates a mid-level from a senior developer

Most developers know SELECT, JOIN, and GROUP BY. Window functions are where the gap between mid and senior starts to show. What makes window functions different GROUP BY collapses rows. You lose the i...