Honeywell interview question

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