SELECT

block_timestamp,

LAG(block_timestamp) OVER(ORDER BY block_number) AS last_block_timestamp,

TIMESTAMPDIFF(SECOND, last_block_timestamp, block_timestamp) AS time_difference

FROM avalanche.core.fact_blocks

WHERE block_timestamp > '2022-06-20'

ORDER BY block_number DESC

SELECT avg(time_difference) as "Average Time Between The Blocks"

FROM tmp