Pregunta de entrevista de Globe Publication

Sql query using join and group by