16.20 - Example: Using the AVG Function - Advanced SQL Engine - Teradata Database

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