Pergunta de entrevista da empresa Hypercell

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