Poly as ( select max(tx_count), min(tx_count),avg (tx_count) from polygon.core.fact_blocks), soly as (select max(tx_count), min(tx_count),avg (tx_count)from solana.core.fact_blocks),

ethy as (select max(tx_count), min(tx_count),avg (tx_count)from ethereum.core.fact_blocks), arby as (select max(tx_count), min(tx_count),avg (tx_count)from arbitrum.core.fact_blocks),

opty as (select max(tx_count), min(tx_count),avg (tx_count)from optimism.core.fact_blocks) select 'Polygon' as blockchain, * from Poly UNION select 'solana' as blockchain, * from soly UNION

select 'Ethereum' as blockchain, * from ethy UNION select 'Arbitrum' as blockchain, * from arby UNION select 'Optimism' as blockchain, * from opty