Select Code to Download

(
  FOOID       number,
  FOOTYPE     varchar,
  AMOUNT      number

(
  FOOID       number,
  FOOTYPE     varchar,
  AMOUNT      number,

)

select sum(amount), footype
from foo
group by footype

select sum(amount), footype
from foo
group by footype

select sum(sum_amount), footype
from (
...
    group by footype
)
group by footype

select sum(amount), footype
from foo
where databaseid in (1,2,3)
group by footype

------------
:Wq
Not an editor command: Wq