Pregunta de entrevista de CARS24.com

SQL query. Performance of subqueries and joins