优化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 BY aN

SELECT COALESCE(COUNT(a.ID), 0) AS B2, a.NODE_NAME AS A2 FROM xc_damage a WHERE a.NODE_NAME IN ('修复', '合格', '不合格') AND a.PATROL_TYPE_NAME = '道路' AND a.endtime BETWEEN '20230410' AND '20230510' GROUP BY a.NODE_NAME