Sum Function Example

This example calculates the total sales (including freight costs) for orders shipped to the United Kingdom.

SELECT Sum([Order Amount] + [Freight]) FROM Orders WHERE [Ship Country] = 'UK'