as(

select block_timestamp

, lag(block_timestamp,1) over(order by block_timestamp) as block_timestamp_lag , timediff(second, block_timestamp_lag, block_timestamp) as block_timediff

from ethereum.core.fact_blocks

order by block_timestamp

) ,

block_time2

as(

select block_timestamp

, lag(block_timestamp,1) over(order by block_timestamp) as block_timestamp_lag , timediff(second, block_timestamp_lag, block_timestamp) as block_timediff

from polygon.core.fact_blocks

order by block_timestamp) ,

block_time3

as(

select block_timestamp

, lag(block_timestamp,1) over(order by block_timestamp) as block_timestamp_lag , timediff(second, block_timestamp_lag, block_timestamp) as block_timediff

from arbitrum.core.fact_blocks

order by block_timestamp)

select 'ethereum' as type , min(block_timediff) as min_block_time , max(block_timediff) as max_block_time , avg(block_timediff)

from block_time1

UNION ALL

select 'polygon' as type , min(block_timediff) as min_block_time , max(block_timediff) as max_block_time , avg(block_timediff)

from block_time2

UNION ALL

select 'arbitrum' as type , min(block_timediff) as min_block_time , max(block_timediff) as max_block_time , avg(block_timediff)

from block_time3