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