Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?(Choose two.)
选项：

A: Aggregating functions and columns used in HAVING clauses must be specified in theSELECT list of a query
B: WHERE and HAVING clauses can be used in the same statement only if applied to differentTable columns
C: The HAVING clause can be used with aggregating functions in subqueries
D: The WHERE clause can be used to exclude rows before dividing them into groups
E: The WHERE clause can be used to exclude rows after dividing them into groups