NavidCopy of Untitled Query
    Updated 2022-11-09
    with miners as
    (
    select
    BLOCK_AUTHOR as miner,
    round(count(distinct BLOCK_ID)/10)+1 as blocks_count
    from
    near.core.fact_blocks
    where
    BLOCK_TIMESTAMP>CURRENT_DATE-60
    group by
    miner
    )
    select
    blocks_count*10 as cnt,
    count(*) as frequency
    from
    miners
    group by
    blocks_count
    order by
    blocks_count
    Run a query to Download Data