Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose
three.)
A.
WHERE and HAVING clauses cannot be used together in a SQL statement.
B.
The HAVING clause conditions can have aggregate functions.
C.
The HAVING clause conditions can use aliases for the columns.
D.
The WHERE clause is used to exclude rows before the grouping of data.
E.
The HAVING clause is used to exclude one or more aggregated results after grouping data.
BDE are correct, not A
The WHERE clause restricts rows in a dataset before grouping, while the
HAVING clause restricts them after grouping.
Correct is B-D-E