msafadoosttransactions in solana blocks
    Updated 2022-07-25
    WITH total AS (
    SELECT BLOCK_TIMESTAMP as sec1,
    BLOCK_HEIGHT as BLOCK_HEIGHT1,
    row_number()over(ORDER by BLOCK_HEIGHT1) as rank
    FROM flow.core.fact_blocks
    GROUP by 1,2
    ),
    limited AS (
    SELECT BLOCK_TIMESTAMP as sec2,
    BLOCK_HEIGHT as BLOCK_HEIGHT2,
    row_number()over(ORDER by BLOCK_HEIGHT2) as rank
    FROM flow.core.fact_blocks
    WHERE BLOCK_HEIGHT != (SELECT min(BLOCK_HEIGHT) FROM flow.core.fact_blocks)
    GROUP by 1,2
    )

    SELECT BLOCK_HEIGHT1,
    CASE
    WHEN BLOCK_HEIGHT2-BLOCK_HEIGHT1 = 1 THEN cast(DATEDIFF(SECOND, sec1, sec2) as INT)
    END AS secs
    FROM total JOIN limited USING(rank)
    GROUP by 1,2 HAVING(secs=0)
    ORDER by 1 ASC
    LIMIT 10
    Run a query to Download Data