优化sql 要求 修复 合格 不合格 其中一个不存在时返回为0 比如修复为0 A2字段返回为修复SELECT COUNT aID AS B2 aNODE_NAME AS A2 FROM xc_damage a WHERE aNODE_NAME IN 修复 合格 不合格 AND aPATROL_TYPE_NAME = 道路 AND aendtime BETWEEN 20230410 AND

SELECT SUM(CASE WHEN a.NODE_NAME = '修复' THEN 1 ELSE 0 END) AS 修复, SUM(CASE WHEN a.NODE_NAME = '合格' THEN 1 ELSE 0 END) AS 合格, SUM(CASE WHEN a.NODE_NAME = '不合格' THEN 1 ELSE 0 END) AS 不合格 FROM xc_damage a WHERE a.NODE_NAME IN ('修复', '合格', '不合格') AND a.PATROL_TYPE_NAME = '道路' AND a.endtime BETWEEN '20230410' AND '20230510'