SELECT

block_number,

lag(block_number,1) OVER (order by block_number) as pblock_number,

block_number-pblock_number as diff,

block_timestamp,

lag(block_timestamp,1) OVER (ORDER BY block_number) as ptime,

DATEDIFF(seconds, ptime, block_timestamp) as block_time_seconds

from avalanche.core.fact_blocks

WHERE 1=1

AND block_timestamp::date = '2022-06-24'

block_number,

pblock_number,

diff,

block_time_seconds,

block_timestamp, ptime

from base

WHERE diff>1

ORDER BY DIFF DESC