mlhsolana--
    Updated 2022-07-23
    WITH block1 AS (
    SELECT BLOCK_TIMESTAMP AS date1,
    BLOCK_ID AS block1,
    tx_count as tx1
    FROM SOLANA.core.fact_blocks
    ),
    block2 AS (
    SELECT BLOCK_TIMESTAMP AS date2,
    BLOCK_ID AS block2,
    tx_count as tx2
    FROM SOLANA.core.fact_blocks
    ),
    Performance AS (
    select *
    from block1 join block2
    where block1 = block2 - 1
    order by block1 desc
    )
    SELECT min (DATEDIFF(SECOND, date1, date2)) AS MINI,
    max (DATEDIFF(SECOND, date1, date2)) AS MAXI,
    sum (DATEDIFF(SECOND, date1, date2))/COUNT (*) AS AVG
    FROM Performance
    Run a query to Download Data