order by Aggregate calls are not allowed here code example

Example: aggregate functions are not allowed in WHERE

Try using the condition inside the "Having" clause