*List of most widely used window functions in SQL:* ROW_NUMBER(): Assigns consecutive numbers starting from 1 to all rows in the table RANK: Assigns a rank value to each row within each ordered partition of a result set NTILE(): Returns the group number for each of the rows in the partition LEAD() and LAG(): Compares the rows with their previous or next rows PERCENTILE_CONT: Compares each employee's salary with the average salary in his or her department More resources for data analysts: https://t.me/sqlspecialist