Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
The HAVING clause can be used with aggregating functions in subqueries because it allows you to filter groups of rows after applying aggregate functions. The WHERE clause is used to exclude rows before they are divided into groups, which makes it a preliminary filter that helps in determining which rows are included in the groupings for aggregate functions.
CD for me
C is incorrect because subqueries using aggregate functions typically do not use HAVING clauses; rather, HAVING is used in the outer query to filter the results of aggregates