Pergunta de entrevista da empresa CARS24.com

SQL query. Performance of subqueries and joins