sql 查询中count,case统计问题

Question

哪位帮忙看看怎么简化sql

SELECT a.monthCount,a.monthAlarmingCount,a.monthEndAlarmCount,b.monthEarlyWarningCount,b.monthInFaultAlarmCount,c.monthEndEarlyWarningCount,c.monthEndFaultCount from
(SELECT COUNT(*) as 'monthCount',COUNT(case when alarm_status = 1 then 1 end) as 'monthAlarmingCount', COUNT(case when alarm_status = 2 then 2 end) as 'monthEndAlarmCount' from sol_alarm_inverter_plant where DATE_FORMAT(alarm_time,'%Y-%m') = DATE_FORMAT(NOW(),'%Y-%m') and plant_id = 38147)as a,
(SELECT COUNT(case when alarm_level = 1 then 1 end) as'monthEarlyWarningCount', COUNT(case when alarm_level = 2 then 2 end) as 'monthInFaultAlarmCount'from sol_alarm_inverter_plant where DATE_FORMAT(alarm_time,'%Y-%m') = DATE_FORMAT(NOW(),'%Y-%m') and plant_id = 38147 and alarm_status =1)AS b,
( SELECT COUNT(case when alarm_level = 1 then 1 end) as'monthEndEarlyWarningCount', COUNT(case when alarm_level = 2 then 2 end) as'monthEndFaultCount'from sol_alarm_inverter_plant where DATE_FORMAT(alarm_time,'%Y-%m') = DATE_FORMAT(NOW(),'%Y-%m') and plant_id = 38147 and alarm_status =2)AS c

Answer 1

具体是什么数据库，可以用with子句进行改善，提高可读性