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)select avg(block_timediff)

, max(block_timediff) as max_block_time, min(block_timediff) as min_block_time

from block_time