Aggregation Functions

Function	Description	Examples
AVG	Calculates the average of the values from the selected column.	Display the average hours worked for a department.
COLLECT	Takes a database column and creates a nested table from the selected rows; associates a list of data with a specific value, enabling aggregation of data into a collection.	Create a list of employees within a department.
COUNT	Lists the number of rows returned from the database for the selected column.	Determine the number of employee records returned from a database query.
MAX	Returns the maximum value of the selected column's values.	Display the maximum hours worked.
MIN	Returns the minimum value of the selected column's values.	Display the minimum hours worked.
STDDEV	Returns the standard deviation of the selected column's values.	Apply standard deviation to values, for example, for forecasting.
SUM	Calculates the sum of the values from the selected column.	Display the total hours worked for a department.