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'