Queries can be summarized or aggregated into fewer rows using the GROUP BY and ____ clauses.
A) FROM
B) WHERE
C) HAVING
D) ORDER BY

Question

Quizplus · Accepted Answer

The GROUP BY clause is used to group the results by a specified column name, while the HAVING clause is used to filter and aggregate the grouped results. Using the HAVING clause allows for further filtering after the grouping has occurred. Therefore, the correct choice is C.

Queries Can Be Summarized or Aggregated into Fewer Rows Using