Avg Function Example

This example uses the Orders table to calculate the average freight charges for orders with freight charges over $100.

SELECT Avg(Freight) AS [Average Freight] 
FROM Orders 
WHERE Freight > 100;)