select date_trunc ({{Time_Interval}},date) as date,
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 (fees) as "Fees [$]",
sum (Revenue) as "Revenue [$]"
from external.defillama.fact_protocol_fees_revenue
where chain ilike 'Avalanche'
and "Project Name" ilike '%{{Project_Name}}%'
group by 1,2
order by 1 desc