Sbhn_NPtotal blocks produced
    Updated 2022-10-06
    WITH tab1 as (
    SELECT
    miner,
    COUNT(*) blocks
    FROM ethereum.core.fact_blocks
    WHERE block_timestamp > '2022-09-16'
    GROUP BY 1
    )

    SELECT
    median(blocks),
    avg(blocks),
    max(blocks)
    FROM tab1





    Run a query to Download Data