SELECT COUNT (a.BLOCK_ID), a."Time Between Blocks"
FROM (
SELECT
BLOCK_ID,
DATEDIFF(second, LAG(block_timestamp) OVER (ORDER BY BLOCK_ID), block_timestamp) AS "Time Between Blocks"
FROM flipside_prod_db.mdao_harmony.blocks
WHERE BLOCK_TIMESTAMP BETWEEN '2022-06-23' AND '2022-07-21') a
WHERE "Time Between Blocks" IS NOT NULL
GROUP BY "Time Between Blocks"