Domanda di colloquio di Hypercell

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