select 'Polygon' as type , avg(tx_count) as avg_tx
from polygon.core.fact_blocks
group by 1
UNION
select 'Flow' as type , avg(tx_count) as avg_tx
from flow.core.fact_blocks
group by 1
UNION
select 'Solana' as type , avg(tx_count) as avg_tx
from solana.core.fact_blocks
group by 1
UNION
select 'Arbitrum' as type , avg(tx_count) as avg_tx
from arbitrum.core.fact_blocks
group by 1
UNION
select 'Optimism' as type , avg(tx_count) as avg_tx
from optimism.core.fact_blocks
group by 1