case

when BALANCE/1e6 between 0 and 10 then 'Shrimp'

when BALANCE/1e6 between 10 and 100 then 'Crab'

when BALANCE/1e6 between 100 and 1000 then 'ctopus'

when BALANCE/1e6 between 1e3 and 10e3 then 'Fish'

when BALANCE/1e6 between 10e3 and 100e3 then 'Dolphin'

when BALANCE/1e6 between 100e3 and 1000e3 then 'Shark'

when BALANCE/1e6 between 1000e3 and 10000e3 then 'Whale' else 'Humpback' end as wallet ,

count(*) as number ,

sum(BALANCE/1e6) as volume

from

axelar.core.fact_daily_balances

where

date='2023-03-01'

group by 1