SQL优化：统计道路巡检结果，缺失状态返回0

SELECT COUNT(a.ID) AS B2, n.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;