SQL 查询过去一年每月销售额

SELECT DATE_FORMAT(created_at, '%Y-%m') AS month, SUM(total) AS sales FROM Orders WHERE created_at >= DATE_SUB(NOW(), INTERVAL 1 YEAR) GROUP BY month ORDER BY month ASC;