Honeywell Interview Question

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