The SUM function
The following query calculates the total ship_weight of
orders that were shipped on July 13, 1998.
Figure 1. Query
SELECT SUM (ship_weight) FROM orders
WHERE ship_date = '07/13/1998'; Figure 2. Query
result
(sum)
130.5