0xKofirev
Updated 2023-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
WITH monthly_revenue AS (
SELECT
PROTOCOL,
SUM(CASE WHEN YEAR(DATE) = 2023 AND MONTH(DATE) = 1 THEN REVENUE ELSE 0 END) AS jan_revenue,
SUM(CASE WHEN YEAR(DATE) = 2023 AND MONTH(DATE) = 2 THEN REVENUE ELSE 0 END) AS feb_revenue,
SUM(CASE WHEN YEAR(DATE) = 2023 AND MONTH(DATE) = 3 THEN REVENUE ELSE 0 END) AS march_revenue,
SUM(CASE WHEN YEAR(DATE) = 2023 AND MONTH(DATE) = 4 THEN REVENUE ELSE 0 END) AS april_revenue
FROM
external.defillama.fact_protocol_fees_revenue
-- WHERE
-- DATE >= '2023-02-01' AND DATE <= '2023-04-30'
GROUP BY
PROTOCOL
)
SELECT
PROTOCOL,
april_revenue,
march_revenue,
feb_revenue,
jan_revenue
FROM
monthly_revenue
WHERE
april_revenue > march_revenue AND march_revenue > feb_revenue
ORDER BY 2 DESC
;
Run a query to Download Data