OLX Group Interview Question

SQL questions based on window functions and cte