One compute clause can apply the same aggregate to several columns. This query finds the sum of the 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.
