MySQL 查询指定年份12个月份的订单支付金额

-- MySQL 查询指定年份12个月份的订单支付金额
SELECT
		user_id,
		SUM(case month(a.create_time) when 1 then money else 0 end) AS Jan,
		SUM(case month(a.create_time) when 2 then money else 0 end) AS Feb,
		SUM(case month(a.create_time) when 3 then money else 0 end) AS Mar,
		SUM(case month(a.create_time) when 4 then money else 0 end) AS Apr,
		SUM(case month(a.create_time) when 5 then money else 0 end) AS May,
		SUM(case month(a.create_time) when 6 then money else 0 end) AS Jun,
		SUM(case month(a.create_time) when 7 then money else 0 end) AS Jul,
		SUM(case month(a.create_time) when 8 then money else 0 end) AS Aug,
		SUM(case month(a.create_time) when 9 then money else 0 end) AS Sep,
		SUM(case month(a.create_time) when 10 then money else 0 end) AS Oct,
		SUM(case month(a.create_time) when 11 then money else 0 end) AS Nov,
		SUM(case month(a.create_time) when 12 then money else 0 end) AS `Dec`
FROM
			sys_order a
WHERE
			year(a.create_time) = 2021
GROUP BY
			user_id