• SUM()
• AVG()
• COUNT()
• MAX()
• MIN()
• FIRST()
• LAST()

Examples:

SELECTCOUNT()SELECTCOUNT(one)SELECTCOUNT(*)

• AGGR() – operations on aggregated values
• ARRAY() – create array of values
• QUART() - 1st quartile
• QUART2() - 2nd quartile
• QUART3() - 3rd quartile
• User-defined aggregators

Quartile aggregations are based on the European calculation.

Example of AGGR() aggregator (here avg1 = avg2)

SELECTSUM(a)AS sm,COUNT(*)AS cnt, \           AGGR(sm/cnt)AS avg1,AVG(a)AS avg2FROM data