WITH Blast AS(

SELECT block_timestamp,

lag(block_timestamp, 1) over (ORDER BY block_timestamp) as polygon_block_lag,

timediff(SECOND, polygon_block_lag, block_timestamp) as polygon_block_timediff,

TX_COUNT

FROM blast.core.fact_blocks

ORDER BY 1

SELECT avg(polygon_block_timediff) AS "Average Block Time",

max(polygon_block_timediff) AS Maximum_Block_Time,

min(polygon_block_timediff) AS Minimum_Block_Time,

avg(TX_COUNT) AS Average_Transaction_Count_Per_Block

FROM Blast