Aggregation functions are usually used with a GROUP BY clause, but
they can also be used in standard FROM-WHERE-SELECT clauses.
| Function | Description | Arguments |
|---|---|---|
avg
|
Calculates the average of a group or collection of values. | Numeric value or identifier/path to a numeric element in a collection. |
count
|
Returns the number of values in a group or collection. | Numeric value or identifier/path to a numeric element in a collection. |
| min | Returns the smallest value in a group or collection. | Numeric value or identifier/path to a numeric element in a collection. |
| max | Returns the largest value in a group or collection. | Numeric value or identifier/path to a numeric element in a collection. |
sum
|
Returns the sum of all the values in a group or collection. | Numeric value or identifier/path to a numeric element in a collection. |