case when protocol ilike '%benqi%' then 'Benqi'

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

when protocol ilike '%GMX%' then 'GMX'

when protocol ilike '%AAVE%' then 'AAVE'

else protocol end as "Project Name",

sum (chain_tvl) as "TVL [$]"

from external.defillama.fact_protocol_tvl

where chain ilike 'Avalanche'

and "Project Name" ilike '%{{Project_Name}}%'

group by 1,2

order by 1 desc