Query editor
SELECTDATE_TRUNC('month', CAST(date AS DATE)) AS month,category,ROUND(SUM(daily_revenue_usd), 2) AS revenue_usdFROM dune.ryrxryr.dataset_defillama_daily_revenueGROUP BY 1, 2ORDER BY 1 ASC, 3 DESC
Query editor
1SELECT2DATE_TRUNC('month', CAST(date AS DATE)) AS month,3category,4ROUND(SUM(daily_revenue_usd), 2) AS revenue_usd5FROM dune.ryrxryr.dataset_defillama_daily_revenue6GROUP BY 1, 27ORDER BY 1 ASC, 3 DESC