CE_AGGREGATION groups the input and computes aggregates for each group.

Supported aggregate functions are count("column"), sum("column"), max("column"), min("column"). Use sum("column")/count("column") to compute the average.

Example:
ot_books1 = CE_AGGREGATION(:it_books, [COUNT ("PUBLISHER") AS CNT], ["YEAR"]);
Is equivalent to
ot_books2 = SELECT COUNT (publisher) as cnt, year FROM :it_books GROUP BY year;

Related questions