If the result returned from a subquery must be compared to a group function,then the inner query must be nested in the outer query's ____ clause.
A) GROUP BY
B) WHERE
C) HAVING
D) FROM

Question

If the result returned from a subquery must be compared to a group function,then the inner query must be nested in the outer query's ____ clause.​
A) ​GROUP BY
B) ​WHERE
C) ​HAVING
D) ​FROM

Quizplus · Accepted Answer

When comparing a result returned from a subquery to a group function, the comparison must be done in the HAVING clause. The HAVING clause is used to filter group results after they have been computed by the GROUP BY clause.

If the Result Returned from a Subquery Must Be Compared