aggregate function not allowed in where code example Example: aggregate functions are not allowed in WHERE Try using the condition inside the "Having" clause