SUM

The SUM function returns a sum of all numbers in the set (e.g., Salary Paid).

Syntax

SELECT SUM(…)
SELECT SUM(fact)

Examples

The metric defined by the SUM of the Sales fact would be computed by adding revenue earned from all individual sales transactions: 

SELECT SUM(Sales)
AVG