In SQL what is the function of the GROUP BY clause

In sql what is the function of the group by clause - CompTIA DataSys+ DS0-001

Question

In SQL, what is the function of the GROUP BY clause?

Answers

To sort the result set in either ascending or descending order
To filter records before they are grouped
To aggregate data from multiple rows into a single row
correct

To group rows that have the same values in specified columns

Explanation

The Correct Answer is: D. To group rows that have the same values in specified columns
The GROUP BY clause in SQL is designed to organize rows into groups based on one or more columns that contain the same values. This grouping allows aggregate functions such as COUNT(), SUM(), AVG(), MAX(), and MIN() to be applied to each group independently rather than to the entire dataset as a whole. Essentially, GROUP BY clusters the data into meaningful categories so that calculations or summaries can be performed on each category separately.

Why the other options are incorrect:

A. To sort the result set in either ascending or descending order
Sorting is performed by the ORDER BY clause. It controls the sequence in which rows are returned after the query has been executed but does not affect grouping.
B. To filter records before they are grouped
Filtering before grouping is the job of the WHERE clause. WHERE restricts which rows are included in the query before grouping happens, while GROUP BY focuses on how those rows are organized once selected.
C. To aggregate data from multiple rows into a single row
Aggregation is performed by specific aggregate functions, not by the GROUP BY clause itself. GROUP BY creates the groups on which these functions operate, but it does not do the aggregation process alone.