SQL Window Functions – Made Simple and Intuitive (machinelearningplus.com)

SQL window functions is one of the advanced concepts, understanding which will give you the ability to do complex data wrangling and transformations in SQL.