Pergunta de entrevista da empresa Honeywell

What is the grouped by query in SQL and where we will use this?