case

when volume = 1500 then '1. Shrimp(1500)'

when volume > 1500 and volume <= 2500 then '2. Crab(1500~2500)'

when volume > 2500 and volume <= 3886 then '3. Octopus(2500~3886)'

when volume > 3886 and volume <= 10000 then '4. Fish(3886~10k)'

when volume > 10000 and volume <= 50000 then '5. Dolphin(10k~50k)'

when volume > 50000 and volume <= 100000 then '6. Shark(50k~100K)'

else '7. Whale(>100K)' end as type,

count(distinct claimers) as users,

sum(volume) as total_volume

select

distinct To_ADDRESS as claimers ,

sum(amount) as volume

from arbitrum.core.ez_token_transfers

where CONTRACT_ADDRESS = lower('0xdadeca1167fe47499e53Eb50F261103630974905')

and FROM_ADDRESS = lower('0xb063f2af926af95f08515fd9d5f2397ce97148bf')

and ORIGIN_FUNCTION_SIGNATURE = '0x2f0879f7'

group by 1)

group by 1

order by 1 asc