AVG Function Example | Teradata Vantage - Example: Using the AVG Function - Teradata Vantage - Analytics 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;

Result:

Region  Average (sales)
------  ---------------
North          21840.17
East           55061.32
Midwest        15535.73