select

ORIGIN_FROM_ADDRESS,

count(distinct PLATFORM) as N_DEX

from base.defi.ez_dex_swaps

where PLATFORM is not NULL

group by 1

select

case when N_DEX = 1 then 'A: 1 DEX'

when N_DEX = 2 then 'B: 2 DEXs'

when N_DEX = 3 then 'C: 3 DEXs'

when N_DEX = 4 then 'D: 4 DEXs'

when N_DEX = 5 then 'E: 5 DEXs'

when N_DEX = 6 then 'F: 6 DEXs'

when N_DEX = 7 then 'G: 7 DEXs'

when N_DEX = 8 then 'H: 8 DEXs'

when N_DEX = 9 then 'I: 9 DEXs'

when N_DEX = 10 then 'J: 10 DEXs'

end as status,

count(DISTINCT ORIGIN_FROM_ADDRESS) as N_Users

from tab1

group by 1