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 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),

dexvolumet as (

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 (volume) as "Volume [$]"

from external.defillama.fact_dex_volume

where date = (select max (date) from external.defillama.fact_dex_volume where chain ilike 'Avalanche')

and chain ilike 'Avalanche'

group by 1),

feesrevenuet as (

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'