sql统计总和和各状态数

select g.dept_id,
count(g.dept_id) as "总数",
sum(case g.is_deal when "0" then 1 else 0 end) as "办理",
sum(case g.is_deal when "1" then 1  else 0 end) as "未办理"
from getnumber g where g.style="0" or g.style is null
group by g.dept_id