Summary Query Syntax

AVG([ALL|DISTINCT] expression)

SUM([ALL|DISTINCT] expression)

MIN([ALL|DISTINCT] expression)

MAX([ALL|DISTINCT] expression)

COUNT([ALL|DISTINCT] expression)

COUNT(*)

COMMAND( [ALL|DISTINCT] expression)

A Summary Command (or Function) usually has 3 parts as follows:

The Command or Function Name

Optional Choice of either all data or distinct results

The expression for evaluation

Here are some examples of the commands