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;)