with swaps as ( select
count(DISTINCT(platform)) as total,
origin_from_address
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