AVG Function Example | Teradata Vantage - 17.10 - Example: Using the AVG Function - Advanced SQL Engine - Teradata Database

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

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.