Calsoft interview question

Window function in sql and uses.