Hypercell interview question

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