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
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
声明：该文观点仅代表作者本人，牛骨文系教育信息发布平台，牛骨文仅提供信息存储空间服务。
