avg()

Takes the average of row values in a given column.

avg() follows this syntax.

1SELECT avg(COLUMN_NAME)
2FROM DATASET
3WHERE CONDITION;

j

Introducing SQL for CRM Analytics

Quick Start: Run Your First Query

SQL vs SAQL

SQL Statements

Date Functions

Aggregate Functions

avg()

count()

min()

max()

sum()

stddev_pop()

stddev_samp()

var_pop()

var_samp()

regr_intercept()

regr_slope()

regr_r2()

percentile_cont

percentile_disc

Math Functions

String Functions and Operators

Release Notes

Previous Versions