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;