The following aggregate expression functions are supported:
| Function Name | Description |
|---|---|
| Avg | Returns the average of the values identified by the provided expression. |
| Count | Returns the number of rows returned by a query identified by the provided expression. |
| Max | Returns the maximum value of the provided expression. |
| Median | Represents an inverse distribution function that assumes a continuous distribution model. It takes a numeric or date-time value and returns the middle value or an interpolated value that would be the middle value once the values are sorted. |
| Min | Returns the minimum value of the provided expression. |
| Stddev | Returns the sample standard deviation of the provided expression. |
| Sum | Returns the sum of the values identified by the provided expression. |
| Spatial Extent | Returns the spatial extent of a geometry. |
| Table 1: List of aggregate expression functions | |