case

when volume <= 1000 then '1. Less than 1k $Degen'

when volume > 1000 and volume <= 5000 then '2. Between 1k ~ 5k $Degen'

when volume > 5000 and volume <= 10000 then '3. Between 5k ~ 10k $Degen'

when volume > 10000 and volume <= 100000 then '4. Between 10k ~ 100k $Degen'

when volume > 100000 and volume <= 500000 then '5. Between 100k ~ 500k $Degen'

when volume > 500000 then '6. More than 500k $Degen' end as type,

count(distinct claimers) as users

select

distinct

TO_ADDRESS as claimers ,

sum(amount) as volume

from base.core.ez_token_transfers

where FROM_ADDRESS = '0xa2a5c549a454a1631ff226e0cf8dc4af03a61a75'

and contract_address = '0x4ed4e862860bed51a9570b96d89af5e1b0efefed'

and ORIGIN_FUNCTION_SIGNATURE = '0x2e7ba6ef'

group by 1)

group by 1

order by 2 desc