You can use different aggregates in the same compute clause:
select type, pub_id, price from titles where type like "%cook" order by type, pub_id compute sum(price), max(pub_id) by type
type pub_id price
----------- ------- --------------
mod_cook 0877 2.99
mod_cook 0877 19.99
Compute Result:
--------------- ----
22.98 0877
type pub_id price
----------- ------- --------------
trad_cook 0877 11.95
trad_cook 0877 14.99
trad_cook 0877 20.95
Compute Result:
--------------- ----
47.89 0877
(7 rows affected)
