Example: Using the AVG Function

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Example: Querying the Sales Table for Average Sales by Region

This example queries the sales table for average sales by region and returns the following results.

   SELECT Region, AVG(sales)
   FROM sales_tbl
   GROUP BY Region
   ORDER BY Region;
   
   Region  Average (sales)
   ------  ---------------
   North          21840.17
   East           55061.32
   Midwest        15535.73

For time series examples, see Teradata Vantageā„¢ Time Series Tables and Operations, B035-1208.