优化 SQL 查询：统计不同巡查类型损坏数量

优化后的 SQL：

SELECT COUNT(a.ID) AS B2, a.PATROL_TYPE_NAME AS A2 FROM xc_damage a WHERE a.PATROL_TYPE_NAME IN('道路','桥梁','排水','绿化','泵站','路灯','广场') AND a.endtime BETWEEN '20230410' AND '20230510' GROUP BY a.PATROL_TYPE_NAME ORDER BY count(a.ID) DESC