human 帮我改一下下面的sql语句要求能显示出对应的月份 AI 好的以下是更新后的三个SQL查询语句用于查询从当前时间往前一年内每个月的销售额、卖出商品数和新增用户数即使该月没有任何销售或新增也会被显示出来：1 查询过去一年每个月的销售额：SELECT DATE_FORMATdate_tablemonth Y-m AS month IFNULLSUMtotal 0 AS sal

'%Y-%m') AS month FROM (SELECT 0 AS a UNION SELECT 1 AS a UNION SELECT 2 AS a UNION SELECT 3 AS a UNION SELECT 4 AS a UNION SELECT 5 AS a UNION SELECT 6 AS a UNION SELECT 7 AS a UNION SELECT 8 AS a UNION SELECT 9 AS a) AS a CROSS JOIN (SELECT 0 AS a UNION SELECT 1 AS a UNION SELECT 2 AS a UNION SELECT 3 AS a UNION SELECT 4 AS a UNION SELECT 5 AS a UNION SELECT 6 AS a UNION SELECT 7 AS a UNION SELECT 8 AS a UNION SELECT 9 AS a) AS b CROSS JOIN (SELECT 0 AS a UNION SELECT 1 AS a UNION SELECT 2 AS a UNION SELECT 3 AS a UNION SELECT 4 AS a UNION SELECT 5 AS a UNION SELECT 6 AS a UNION SELECT 7 AS a UNION SELECT 8 AS a UNION SELECT 9 AS a) AS c) date_table LEFT JOIN users u ON DATE_FORMAT(u.created_at, '%Y-%m') = date_table.month AND u.created_at BETWEEN DATE_SUB(NOW(), INTERVAL 1 YEAR) AND NOW() GROUP BY month