CARS24.com interview question

SQL query. Performance of subqueries and joins