SUM

This column function returns the sum of a set of numbers. The argument values must be numbers.

Example:

Using the EMPLOYEE table, return the total bonus (BONUS) paid to clerks (JOB='CLERK').

   SELECT SUM(BONUS)
     FROM EMPLOYEE
     WHERE JOB = 'CLERK'

Returns 2800 when using the sample table.