Which of the following is invalid? (Choose all that apply.)

A.
Referring to an attribute that you group by in the WHERE clause

B.
Referring to an expression in the GROUP BY clause; for example, GROUP BY YEAR(orderdate)

C.
In a grouped query, referring in the SELECT list to an attribute that is not part of

D.
the GROUP BY list and not within an aggregate function Referring to an alias defined in the SELECT clause in
the HAVING clause