SQL · Aggregation and grouping

sum() / avg()

Adds or averages non-null numeric values.

sqlRunnable example sql course

Syntax

sum(column)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20))
SELECT sum(minutes) AS total, avg(minutes) AS average FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.