Avg Function Example

This example uses an Orders table to calculate the average sale for orders over $1000.  You can enter this expression in an SQL statement.

SELECT Avg([Order Amount]) FROM Orders WHERE [Order Amount] > 1000