select

pool_name,

CASE

when platform = "uniswap-v3" then "uniswap"

when platform = "uniswap-v2" then "uniswap"

else platform

end as platform_simple

sum(amount_in_usd) total_volume

from ethereum.defi.ez_dex_swaps

where amount_in_usd is not null

group by 1

order by total_volume desc

limit 5