Sum the values for each region. The SUM and BY statements work together to sum the values of Price and Quantity for each BY group as well as for the whole report. The SUMBY statement limits the subtotals to one for each type of sale.


   by sale_type order_date;
   sum price quantity;
   sumby sale_type;