GROUP BY column-commalist [HAVING expr]
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 provides more ability to manipulate aggregates.
Select AVG(sales_ly), sales_region from customer group by sales_region