Pregunta de entrevista de Hypercell

write a query that needed GROUP BY. basic problem solving question.