为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】：Windows
【CPU】:
【问题描述】： select case when equipment_type=‘S42’ then ‘智能车辆检测’
when equipment_type=‘S06’ then ‘电器灭弧’
when equipment_type=‘S34’ then ‘水质探测’
when equipment_type=‘S36’ then ‘视频监控’
when equipment_type=‘S37’ then ‘车辆识别’
when equipment_type=‘S01’ then ‘智能烟感’
when equipment_type=‘S26’ then ‘智能水箱盖’
when equipment_type=‘S12’ then ‘水浸感知’
when equipment_type=‘S02’ then ‘智能井盖’
when equipment_type=‘S19’ then ‘车闸’
when equipment_type=‘S22’ then ‘违停地磁’
when equipment_type=‘S03’ then ‘智能停车’
when equipment_type=‘S10’ then ‘人脸识别’
when equipment_type=‘S20’ then ‘消防栓闷盖’
when equipment_type=‘S23’ then ‘火灾灭弧’
when equipment_type=‘S05’ then ‘智能手环’
when equipment_type=‘S07’ then ‘智慧电梯’
when equipment_type=‘S11’ then ‘非机动车管理设备’
when equipment_type=‘S25’ then ‘高空抛物摄像机’
when equipment_type=‘S15’ then ‘垃圾箱’
when equipment_type=‘S08’ then ‘二次供水’
when equipment_type=‘S24’ then ‘智能路灯’
when equipment_type=‘S13’ then ‘燃气探测’
when equipment_type=‘S14’ then ‘地下管网’
when equipment_type=‘S17’ then ‘智能门磁’
when equipment_type=‘S16’ then ‘环境感知’
when equipment_type=‘S21’ then ‘消防栓水压’
when equipment_type=‘S09’ then ‘末端水压’
when equipment_type=‘S41’ then ‘鹰眼’
when equipment_type=‘S43’ then ‘人员智能检测’
when equipment_type=‘S45’ then ‘智能视频’
when equipment_type=‘S40’ then ‘智能客流’ end as 设备类型
,cast(count() as numeric) as 设备数
from MHFG_DWD.DWD_AHJD_DEVICES_TXT
where all_features is not null
and equipment_type!=‘S52’ group by 设备类型