You are right for the application order, WHERE condition is applied before grouping and HAVING condition is applied after and both WHERE and HAVING clauses can be present at the same...

I aggree with cliffb

In fact the correct answer should be Sets conditions to a SELECT query, usually use after a GROUP BY clause