Aggregates in a WHERE Clause - Teradata Database - Teradata Vantage NewSQL Engine

Aggregates are not allowed in a WHERE clause except when the clause is part of a correlated subquery inside a HAVING clause, and the aggregate is applied on outer variables.