Which SQL clause is used to group rows that share a property after applying aggregates?

• A. ORDER BY
• B. GROUP BY
• C. WHERE
• D. HAVING

Answer: (B)

Grouping rows that share a property is done by forming groups based on one or more column values. The grouping clause creates those groups so that you can run aggregates like SUM, AVG, or COUNT within each group. Without it, aggregates apply to the entire result set; with it, you get one result per distinct group value.

For example, you might group by department to see total sales per department: SELECT department, SUM(sales) FROM orders GROUP BY department.

If you need to filter after the aggregates are computed, you’d use a clause that applies to the grouped results (HAVING). If you needed to filter individual rows before grouping, you’d use a clause that applies to rows (WHERE). Sorting the final results is handled by ORDER BY.