CASE

WHEN platform ILIKE 'uniswap%' THEN 'Uniswap'

ELSE platform -- Keep other platforms as is

END AS platform,

COUNT(DISTINCT tx_hash) AS transactions,

COUNT(tx_to) AS addresses,

SUM(amount_in_usd) AS transacted_volume_usd

FROM

base.defi.ez_dex_swaps

WHERE

block_timestamp::date >= current_date - 180

GROUP BY

1

ORDER BY

1;