zero-ndoLtSnew miners
    Updated 2022-09-17
    with before_merge as
    (
    select
    miner,
    count(distinct block_number) as blocks_mined
    from ethereum.core.fact_blocks
    where block_number < 15537352
    group by 1
    ),
    after_merge as
    (
    select
    miner,
    count(distinct block_number) as blocks_mined

    from ethereum.core.fact_blocks
    where block_timestamp > CURRENT_DATE - interval ' 2 weeks'
    and block_number >= 15537352
    group by 1
    )
    select am.* from after_merge am where miner not in
    (
    select distinct miner from before_merge
    )
    order by 2 desc limit 10

    Run a query to Download Data