TOTAL for each AGENT

[Aftab Najib]

I have wrote an SQL to get some information from a database that lists all agents and how long they have worked on a task in a particular queue.

Example

AGENT | WORK DONE | QUEUE

A | 2 | GROUP 1
A | 3 | GROUP 2
B | 1 | GROUP 1

What I would like to do is write a query that will add a row to total the number of work AGENT A has done e.g.

AGENT | WORK DONE | QUEUE

A | 2 | GROUP 1
A | 3 | GROUP 2
A | 5 |
B | 1 | GROUP 1

Is this possible? Could somebody please help. Thanks in advance.