GROUP BY and Nonaggregate Operations - Analytics Database - Teradata Vantage

Nonaggregated variables in SELECT, ORDER BY, and HAVING need to appear in the group by list.

All nonaggregate groups in a SELECT expression list or HAVING expression list must be included in the GROUP BY clause.