case

when volume <= 32 then '1. Shrimp(22.6~32)'

when volume > 32 and volume <= 50 then '2. Crab(32~50)'

when volume > 50 and volume <= 100 then '3. Octopus(50~100)'

when volume > 100 and volume <= 500 then '4. Fish(100~500)'

when volume > 500 and volume <= 1000 then '5. Dolphin(500~1K)'

when volume > 1000 and volume <= 5000 then '6. Shark(1K~5K)'

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

count(distinct claimers) as users,

sum(volume) as total_amount

select

distinct tx_to as claimers,

sum(amount) as volume

from solana.core.fact_transfers

where tx_from = '4cZgUw6T8yYQ2CordAfSzS4Q5VKJNyVU3JEX6xGg2Xwy'

and mint = 'NYANpAp9Cr7YarBNrby7Xx4xU6No6JKTBuohNA3yscP'

and tx_to != 'C8FXTcztFpdjMjPZYtu6mMTs3M5fLzNKR7Q6vymkQC8e'

and amount > 0

group by 1

)

group by 1

order by 2 desc