when swap_to_dust_amount > 0 and swap_to_dust_amount < 1 then 'Shrimp 0-1 $DUST' -- Not account for withdrawals

when swap_to_dust_amount >= 1 and swap_to_dust_amount < 10 then 'Crab 1-10 $DUST'

when swap_to_dust_amount >= 10 and swap_to_dust_amount < 50 then 'Octopus 10-50 $DUST'

when swap_to_dust_amount >= 50 and swap_to_dust_amount < 100 then 'Fish 50-100k $DUST'

when swap_to_dust_amount >= 100 and swap_to_dust_amount < 1000 then 'Dolphin 100-1000 $DUST'

when swap_to_dust_amount >= 1000 and swap_to_dust_amount < 10000 then 'Shark 1k-10k $DUST'

when swap_to_dust_amount >= 10000 then 'Whale >10k $DUST' else null end as tier,

count(distinct swapper) as number_of_swappers,

row_number() over (order by number_of_swappers desc) as ranking

from (select swapper, sum(swap_to_amount) as swap_to_dust_amount

from solana.core.fact_swaps

where swap_to_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ' and swap_to_amount > 0 and succeeded = 'True'

group by 1)

group by 1