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