Eman-Raz4- Classification of Users Based on the Number of Staking
    Updated 2022-09-05
    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
    group by 1)
    select group_, count(staker) as staker_count
    from tab1
    group by 1
    Run a query to Download Data