case

when volume <= 100 then '1. Shrimp(<100)'

when volume > 100 and volume <= 1000 then '2. Crab(100~1K)'

when volume > 1000 and volume <= 10000 then '3. Octopus(1K~10K)'

when volume > 10000 and volume <= 100000 then '4. Fish(10K~100K)'

when volume > 100000 and volume <= 1000000 then '5. Dolphin(100K~1M)'

else '6. Whale(>1M)' end as type,

count(distinct claimers) as users,

sum(volume) as total_volume

select

distinct To_ADDRESS as claimers ,

sum(amount) as volume

from blast.core.ez_token_transfers

where contract_address = lower('0xb1a5700fA2358173Fe465e6eA4Ff52E36e88E2ad')

and FROM_ADDRESS = lower('0xf7be503166828fe8565c520d66645ac6a06bbdd7')

and ORIGIN_FUNCTION_SIGNATURE = '0xcd9829d9'

and TO_ADDRESS != '0xa4bd562c37c19c569c5b4418d12d35fa9964931f'

group by 1)

group by 1

order by 1 asc