count(DISTINCT(platform)) as total,

from ethereum.core.ez_dex_swaps

where amount_in_usd < 1000000

group by 2)

select count(DISTINCT(origin_from_address)) as total,

case when total = 1 then '1 Platform'

when total = 2 then '2 Platforms'

when total = 3 then '3 Platforms'

when total = 4 then '4 Platforms'

when total = 5 then '5 Platforms' end as type

from swaps

group by 2