Arokia IT interview question

SQL query was asked based on partition by