# Avg

## Description

Computes the average value of an aggregation of values.

## Syntax

Avg ( n )

## Arguments

`n` is a numeric expression.

## Example

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
```

## Remarks

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.