select COUNT(sendstate )as 小计 ,count( case when sendstate='已经回执' then sendState end)as 投递成功,
COUNT(case when sendState ='投递失败' then sendState end)as 投递失败 ,ISNULL(Depart ,'总计') as 部门
from emsinfo where sendState='已经回执'
or sendState='投递失败' GROUP BY Depart with rollup