【MySQL】mysql分组后重命名

SELECT task_node, COUNT(1) `value`
FROM construction_quality
WHERE delete_flag = 0
GROUP BY task_node
;

SELECT
	(
		CASE task_node
		WHEN "UserTask_0" THEN
			"待整改"
		WHEN "UserTask_1" THEN
			"待审核"
		ELSE
			"已整改"
		END
	) `name`,
	count(1) `value`
FROM
	construction_quality
WHERE
	delete_flag = 0
GROUP BY
	`name`
;