date_trunc('month', DATE) AS date,

SUM(REVENUE) AS Revenue,

SUM(SUM(REVENUE)) OVER (ORDER BY date_trunc('month', DATE)) AS Cumulative_Revenue

external.defillama.fact_protocol_fees_revenue

PROTOCOL = 'Benqi Lending'

AND date >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '12 months'

GROUP BY

date_trunc('month', DATE)

ORDER BY

date_trunc('month', DATE);