AVG Aggregate Function TSQL Tutorial

AVG Example:

CONTRACT_IDAMOUNT
1400
2500
3700

SELECT AVG(c.amount) AS AverageAmount
   FROM contracts c
WHERE c.amount > 400 ;

AverageAmount
600

See also: T-SQL Functions -> Count -> Max -> Min -> Sum