[]
Returns the average value of the numeric values in the group.
Returns the count of non-null values in the group.
Returns the count of all values in the group (including nulls).
Returns the first non-null value in the group.
Returns the last non-null value in the group.
Returns the maximum value in the group.
Returns the minimum value in the group.
No aggregate.
Returns the difference between the maximum and minimum numeric values in the group.
Returns the sample standard deviation of the numeric values in the group (uses the formula based on n-1).
Returns the population standard deviation of the values in the group (uses the formula based on n).
Returns the sum of the numeric values in the group.
Returns the sample variance of the numeric values in the group (uses the formula based on n-1).
Returns the population variance of the values in the group (uses the formula based on n).
Specifies the type of aggregate to calculate over a group of values.