Altimetrik interview question

Window functions and related to sql