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

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
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.