The following example shows only three columns in the select list and gives totals based on all order quantities and all line totals at the end of the results.