Apply an Aggregate to More Than One Column

One compute clause can apply the same aggregate to several columns.

This query finds the sums of prices and advances for each type of cookbook:
select type, price, advance 
from titles 
where type like "%cook" 
order by type 
compute sum(price), sum(advance) by type
type      price            advance 
--------- ---------------- ---------------
mod_cook              2.99       15,000.00 
mod_cook             19.99            0.00 
 
Compute Result:
--------------- ---------------
          22.98       15,000.00 
 
type      price            advance 
--------- ---------------- ---------------
trad_cook            11.95        4,000.00 
trad_cook            14.99        8,000.00 
trad_cook            20.95        7,000.00 
 
Compute Result:
--------------- ---------------
          47.89       19,000.00 
 
(7 rows affected) 

Remember, the columns to which the aggregates apply must also be in the select list.