select 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 [$]",

avg (round ((((CHAIN_TVL_PREV_DAY - chain_tvl) / CHAIN_TVL_PREV_DAY) * 100) * -1)) as "1D TVL Change [%]",

avg (round ((((CHAIN_TVL_PREV_Week - chain_tvl) / CHAIN_TVL_PREV_Week) * 100) * -1)) as "1W TVL Change [%]",

avg (round ((((CHAIN_TVL_PREV_Month - chain_tvl) / CHAIN_TVL_PREV_Month) * 100) * -1)) as "1M TVL Change [%]"

from external.defillama.fact_protocol_tvl

where chain ilike 'Avalanche'

and category in ('Lending','Leveraged Farming','lending')

and CHAIN_TVL_PREV_DAY > 0

and CHAIN_TVL_PREV_Week > 0

and CHAIN_TVL_PREV_Month > 0

and date = (select max (date) from external.defillama.fact_protocol_tvl

where chain ilike 'Avalanche')

group by 1

order by "TVL [$]" desc