ASA SQL User's Guide
  Summarizing, Grouping and Sorting Query Results

The GROUP BY clause: organizing query results into groups

The GROUP BY clause divides the output of a table into groups. You can GROUP BY one or more column names, or by the results of computed columns using numeric data types in an expression.

Using GROUP BY with aggregate functions