with oppools as (select pool_address, pool_name, token0_address as Tokens from optimism.sushi.dim_dex_pools union all select pool_address, pool_name, token1_address from optimism.sushi.dim_dex_pools),
ethpools as (select pool_address, pool_name, token0 as Tokens from ethereum.core.dim_dex_liquidity_pools where platform ='sushiswap' union all select pool_address,pool_name, token1 from ethereum.core.dim_dex_liquidity_pools where platform ='sushiswap')
select 'Optimism' as blockchain,
count (distinct pool_address) as Pools_Count,
count (distinct pool_name) as Pairs_Count,
count (distinct tokens) as Tokens_Count
from oppools
union ALL
select 'Ethereum' as blockchain,
count (distinct pool_address) as Pools_Count,
count (distinct pool_name) as Pairs_Count,
count (distinct tokens) as Tokens_Count
from ethpools