solana_avg,

arbitrum_avg

from

(

select avg(tx_count) as polygon_avg, min(tx_count), max(tx_count)

from polygon.core.fact_blocks

where block_timestamp >= '2022-11-01'

) as polygon

left join

select avg(tx_count) as solana_avg, min(tx_count), max(tx_count)

from solana.core.fact_blocks

where block_timestamp >= '2022-11-01'

) as solana

left join

select avg(tx_count) as arbitrum_avg, min(tx_count), max(tx_count)

from arbitrum.core.fact_blocks

where block_timestamp >= '2022-11-01'

) as arbitrum