sql 分组查询统计数据并汇总

不说废话 

SELECT case when c1.custom_principal is null then '统计' else c1.custom_principal end as '客服' ,count(*) as '总数量',
sum(CASE WHEN c1.custom_communicate='1' THEN 1 ELSE 0 END) as '已沟通' ,
sum(CASE WHEN c1.custom_communicate='0' THEN 1 ELSE 0 END) as '未沟通' ,
sum(CASE WHEN c1.custom_intention='0' THEN 1 ELSE 0 END) as '无意向' ,
sum(CASE WHEN c1.custom_intention='1' THEN 1 ELSE 0 END) as '有意向' ,
sum(CASE WHEN c1.custo_Signing='0' THEN 1 ELSE 0 END) as '未签单' ,
sum(CASE WHEN c1.custo_Signing='1' THEN 1 ELSE 0 END) as '已签单' 
from custom c1 group by c1.custom_principal WITH ROLLUP