OLX Group interview question

SQL questions based on window functions and cte