分组再对分组进行数据统计
select
(select a_name from mps_area where p_areaid = a_id) as p_area,
(select u_name from mps_uptown where p_uptown = u_id) as p_uptown,
count(*) as p_number,p_areaid
,SUM(CASE p_result WHEN '正常' THEN 1 END) AS [sum]
,SUM(CASE p_result WHEN '异常' THEN 1 END) AS [sum1]
from mps_patrol group by p_areaid,p_uptown