chain,

SUM(volume) AS total_volume

FROM external.defillama.fact_dex_volume

WHERE date >= '2023-04-01'

AND date < '2024-05-01'

GROUP BY 1

ORDER BY 2 DESC