Pergunta de entrevista da empresa Cognizant

How does GROUP BY work?