human 我的订单表结构是CREATE TABLE Orders id int NOT NULL AUTO_INCREMENT COMMENT 订单的唯一标识符 user_id int NOT NULL COMMENT 订单所属用户的唯一标识符 status varchar255 NOT NULL COMMENT 订单的状态 total decimal102 NOT NULL COMM

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;