SUM with GROUP BY in Teradata

Syntax:
SELECT column1, SUM(expression )
FROM tables
WHERE predicates
GROUP BY column1;


Example:
idnamework_datedaily_typing_pages
1Ebi2007-01-24250
2Robert2007-05-27220
3Jack2007-05-06170
3Jack2007-04-06100
4Jill2007-04-06220
5Zara2007-06-06300
5Zara2007-02-06350

SELECT name, SUM(daily_typing_pages)
FROM employee_tbl 
GROUP BY name;


Result:
nameSUM(daily_typing_pages)
Jack270
Jill220
Ebi250
Robert220
Zara650