Aggregates Aggregate

avg()

Calculates the average value for all tuples in x.

Arguments & returns

11 overloads

Aggregate

SELECT SUM(x) / COUNT(*)
FROM (VALUES
  (10),
  (20),
  (NULL)
) AS sample("x");

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example with sample data · Run to view results.

Compare the average with the median to see how an unusually large value changes your summary.

SELECT
  avg(yield_kg) AS average,
  median(yield_kg) AS median
FROM (VALUES (12), (14), (15), (16), (98))
  AS harvest(yield_kg);

Haybarn WASM 1.5.5-rc3 · In your browser

Guide recipe · Run to view results.