AVG Function Example | VantageCloud Lake - Example: Using the AVG Function - Teradata Vantage

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.