Distincts and Multiple Aggregate Distincts
Teradata Database supports the use of:
For example:
SELECT g, SUM(DISTINCT a), SUM(DISTINCT b)
FROM T
GROUP BY g
COUNT(DISTINCT c) > 5;
The feature simplifies SQL generation.