A as( select date, protocol, sum(revenue) as revenue

from external.defillama.fact_protocol_fees_revenue

where PROTOCOL in ('Maestro','Unibot','Banana Gun')

group by 1,2),

B as(

select *, sum(revenue) over(partition by protocol order by date) as revenue_growth

from A )

select * from B

where date(date) >= '2023-04-01'

order by date desc, revenue_growth desc