CASE WHEN s.platform like 'dodo%' THEN 'dodo'

WHEN s.platform like 'kyberswap%' THEN 'kyberswap'

WHEN s.platform like 'pancakeswap%' THEN 'pancakeswap'

WHEN s.platform like 'trader-joe%' THEN 'trader-joe'

WHEN s.platform like 'hashflow%' THEN 'hashflow'

WHEN s.platform like 'dodo%' THEN 'dodo'

ELSE s.platform

END AS platform,

AVG(tx_fee) as avg_tx_fee

FROM ethereum.defi.ez_dex_swaps s

JOIN ethereum.core.fact_transactions tx ON s.tx_hash = tx.tx_hash

WHERE s.block_timestamp >= '2020-01-01'

GROUP BY platform

ORDER BY platform;