SQL — Group By
Syntax
GROUP BY column-commalist [HAVING expr]
Description
The BASIS SQL Engine supports the GROUP BY clause on SELECT statements. The GROUP BY clause provides the ability to group similar data so that a single result row reflects the accumulation of data from one or more physical rows. This also adds functionality to your SELECT statement and gives you more ability to manipulate aggregates.
Example
Select AVG(sales_ly), sales_region from customer group by sales_region