Evaluation Order of WHERE, GROUP BY, and HAVING Clauses - Teradata Vantage - Analytics Database

When the WHERE, GROUP BY, and HAVING clauses are used together in a SELECT statement, the order of evaluation is as follows:

1. WHERE
2. GROUP BY
3. HAVING