roketeth 12
    Updated 2022-09-27
    with tab1 as (select eth_from_address as staker, count(tx_hash) as stake_count, case
    when stake_count=1 then 'Staking Count=1'
    when stake_count>1 and stake_count<=5 then '1<Staking Count<=5'
    when stake_count>5 and stake_count<=10 then '5<Staking Count<=10'
    when stake_count>10 and stake_count<=50 then '10<Staking Count<=50'
    when stake_count>50 and stake_count<=100 then '50<Staking Count<=100'
    when stake_count>100 then 'Staking Count>100'
    end as Group_
    from ethereum.core.ez_eth_transfers
    where (
    eth_to_address='0x84db6ee82b7cf3b47e8f19270abde5718b936670' -- Ankr
    or eth_to_address='0x39dc6a99209b5e6b81dc8540c86ff10981ebda29' --staked.us
    or eth_to_address='0x0194512e77d798e4871973d9cb9d7ddfc0ffd801' --stakefish
    )
    group by 1)
    select group_, count(staker) as staker_count
    from tab1
    group by 1
    Run a query to Download Data