case when protocol ilike '%joe%' then 'Trader Joe'

when protocol ilike '%uniswap%' then 'Uniswap'

when protocol ilike '%kyberswap%' then 'Kyberswap'

when protocol ilike '%hashflow%' then 'Hashflow'

when protocol ilike '%sushiswap%' then 'Sushiswap'

when protocol ilike '%Balancer%' then 'Balancer'

when protocol ilike '%platypus%' then 'Platypus'

when protocol ilike '%curve%' then 'Curve'

else initcap (protocol) end as dex,

sum (chain_tvl) as tvl

from external.defillama.fact_protocol_tvl

where category ilike 'dexes'

and chain ilike 'Avalanche'

and dex ilike '%{{Project_Name}}%'

group by 1,2

order by 1 desc