SQL functions (ROW_NUMBER, RANK, LAG, LEAD, SUM OVER, etc.) introduced in MySQL 8.0 that perform calculations across a set of rows related to the current row, without collapsing rows like GROUP BY does.
