DISTINCT

CASE when platform like '%uniswap%' then 'Uniswap'

when platform like '%pancakeswap%' then 'Pancakeswap'

when platform like '%dodo%' then 'Dodo'

when platform like '%kyberswap%' then 'Kyberswap'

when platform like '%hashflow%' then 'Hashflow'

else platform

end as Platform

,count(tx_hash) Transanctions

,count( DISTINCT sender) User

ethereum.defi.ez_dex_swaps

GROUP BY 1