优化sql 要求 修复 合格 不合格 其中一个不存在时返回为0SELECT 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 20230510 GROUP B

SELECT COUNT(a.ID) AS B2, a.NODE_NAME AS A2 FROM (SELECT '修复' AS NODE_NAME UNION ALL SELECT '合格' UNION ALL SELECT '不合格') AS n LEFT JOIN xc_damage a ON a.NODE_NAME = n.NODE_NAME AND a.PATROL_TYPE_NAME = '道路' AND a.endtime BETWEEN '20230410' AND '20230510' GROUP BY n.NODE_NAME;