NewAvg creates a new Avg node.

NewCount creates a new Count node.

NewCountDistinct creates a new CountDistinct node.

NewFirst returns a new First node.

NewJSONArrayAgg creates a new JSONArrayAgg function.

NewJSONObjectAgg creates a new JSONArrayAgg function.

NewLast returns a new Last node.

NewMax returns a new Max node.

NewMin creates a new Min node.

NewSum returns a new Sum node.

ErrUnsupportedJSONFunction is returned when a unsupported JSON function is called.

Avg node to calculate the average from numeric column.

Count node to count how many rows are in the result set.

CountDistinct node to count how many rows are in the result set.

First aggregation returns the first of all values in the selected column.

JSON_ARRAYAGG(col_or_expr) [over_clause] JSONArrayAgg Aggregates a result set as a single JSON array whose elements consist of the rows.

JSON_OBJECTAGG(key, value) [over_clause] JSONObjectAgg Takes two column names or expressions as arguments, the first of these being used as a key and the second as a value, and returns a JSON object containing key-value pairs.

Last aggregation returns the last of all values in the selected column.

Max aggregation returns the greatest value of the selected column.

Min aggregation returns the smallest value of the selected column.

Sum aggregation returns the sum of all values in the selected column.