from polygon.core.fact_blocks

UNION

select avg(tx_count) as Average_transaction_count, 'Optimism' as label

from optimism.core.fact_blocks

UNION

select avg(tx_count) as Average_transaction_count, 'Arbitrum' as label

from arbitrum.core.fact_blocks

UNION

select avg(tx_count) as Average_transaction_count, 'Flow' as label

from flow.core.fact_blocks

UNION

select avg(tx_count) as Average_transaction_count, 'Solana' as label

from solana.core.fact_blocks

UNION

select avg(tx_count) as Average_transaction_count, 'BSC' as label

from bsc.core.fact_blocks

UNION

select avg(tx_count) as Average_transaction_count, 'Avalanche' as label

from avalanche.core.fact_blocks

UNION

select avg(tx_count) as Average_transaction_count, 'Ethereum' as label

from ethereum.core.fact_blocks

order by AVERAGE_TRANSACTION_COUNT desc