The following ANSI-standard SQL aggregate functions are available to local SQL for use with data retrieval:

SUM( ), for totaling all numeric values in a column

AVG( ), for averaging all non-NULL numeric values in a column

MIN( ), for determining the minimum value in a column

MAX( ), for determining the maximum value in a column

COUNT( ), for counting the number of values in a column that match specified criteria

Complex aggregate expressions are supported, such as

SUM( Field * 10 )  

SUM( Field ) * 10 

SUM( Field1 + Field2 )