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

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