lag (block_timestamp) over (order by block_timestamp) as date2,

datediff (second,date2,date1) as Diff

from osmosis.core.fact_blocks),

osmosis as (select avg(Diff) as Average_Time,

min(Diff) as Minimum_Time,

max(Diff) as Maximum_Time

from osmosis_data)

select * from osmosis