Create a stored procedure out of the INVOICE table that selects a field as the sum of Total and Shipping if Subtotal is less than 100 and selects a field as the Total only if Subtotal is equal or greater than 100.

MySQL format,