SQL 优化：统计节点状态数量，缺失状态返回 0

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'