Question 79:
Which three statements are true regarding the SQL WHERE and HAVING clauses?
Answer options:
A. The HAVING clause conditions can have aggregating functions. B. The HAVING clause conditions can use aliases for the columns. C. The WHERE and HAVING clauses cannot be used together in a SQL statement. D. The WHERE clause is used to exclude rows before grouping data. E. The HAVING clause is used to exclude one or more aggregated results after grouping data.