Arokia IT Interview Question

SQL query was asked based on partition by