|Functions / Aggregation Functions|
Computes the average value of an aggregation of values.
Avg ( n )
n is a numeric expression.
Returns the average and standard deviation of each continent's female population.
select Continent, Avg(Pop_Fem) as Average, StdDev(Pop_Fem) as StandardDeviation FROM countries GROUP BY Continent
Avg is an aggregation function which can only be used in an aggregating Select statement. Null values are ignored. If there are only null values supplied in the aggregation, then a null value is returned.