(
  FOOID       number,
  FOOTYPE     varchar,
  AMOUNT      number

##</code><code>##

(
  FOOID       number,
  FOOTYPE     varchar,
  AMOUNT      number,

##</code><code>##

)

##</code><code>##

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

##</code><code>##

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

##</code><code>##

select sum(sum_amount), footype
from (
	select sum(amount) as sum_amount, footype
	from db1.foo
	group by footype
	UNION ALL
	select sum(amount) as sum_amount, footype
	from db2.foo
	group by footype
	UNION ALL
	...
	UNION ALL
	select sum(amount) as sum_amount, footype
	from dbN.foo
	group by footype
)
group by footype

##</code><code>##

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

##</code><code>##

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