Ocp1z0-047:group BY clause

This question is the test where group by has the order ...

Answer a is not correct: the Where should be placed before group by

Answer b is incorrect: The HAVING clause is conditional on a multiline function (Sum,avg,max,min,count)

Answer c is incorrect: Where should be placed before group by

Refer to the following: (in fact, having also can be placed in front of group by)

SELECT column, Group_function

From table

[WHERE condition]

[GROUP by Group_by_expression]

[Having group_condition]

[Order by column];

Answer: D