Infosys interview question

Question on window function in SQL