aggregate functions not allowed sql code example

Example: aggregate functions are not allowed in WHERE

Try using the condition inside the "Having" clause