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