with tab1 as

(select DELEGATOR as staker, count(tx_id) 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 flow.core.ez_staking_actions

where action in ('DelegatorTokensCommitted','TokensCommitted')

group by 1)

select group_, count(staker) as staker_count

from tab1

group by 1