select top 3

BLOCK_NUMBER

, TX_COUNT as Total_transactions

from arbitrum.core.fact_blocks

order by Total_transactions desc

) ,

lst_polygon as (

select top 3

BLOCK_NUMBER

, TX_COUNT as Total_transactions

from polygon.core.fact_blocks

order by Total_transactions desc

) ,

lst_ethereum as (

select top 3

BLOCK_NUMBER

, TX_COUNT as Total_transactions

from ethereum.core.fact_blocks

order by Total_transactions desc

select 'arbitrum' as type , * from lst_arbitrum

union all

select 'polygon' as type , * from lst_polygon

union all

select 'ethereum' as type , * from lst_ethereum