Avg

Retrieve the average price from the “Price” column in the “Products” table.

SELECT Avg(Price) AS AveragePrice FROM Products;

Definition and Usage

The Avg() function calculates the average value of an expression, excluding NULL values.

Avg(expression)

Parameter	Description
expression	Required: A numerical value, which can be either a field or a formula.

Works in:

From Access 2000

Select products where the price exceeds the average price.

SELECT * FROM Products
WHERE Price > (SELECT Avg(Price) FROM Products);