Pregunta de entrevista de Tokopedia

SQL question related to Join table and subqueries