with polygon as (select
LENDING_POOL as Pools,
sum(amount) as Volume_Deposited
--'Polygon' as type
from polygon.sushi.ez_lending
where action = 'Deposit'
and SYMBOL in ('USDC', 'USDT', 'DAI', 'UST', 'USDN')
group by 1
),
ethereum as (
select
LENDING_POOL as Pools,
sum(amount) as Volume_Deposited
--'Ethereum' as type
from ethereum.sushi.ez_lending
where action = 'Deposit'
and symbol in ('USDC', 'USDT', 'DAI', 'UST', 'USDN')
group by 1
)
select * from ethereum
union all
select * from polygon