56,678
社区成员
发帖
与我相关
我的任务
分享
select 系别,sum(case when 缺勤状态=0 then 1 else 0 end) as 旷课人数,
sum(case when 缺勤状态=1 then 1 else 0 end) as 早退人数,
sum(case when 缺勤状态=2 then 1 else 0 end) as 迟到人数,
sum(case when 缺勤状态=3 then 1 else 0 end) as 病假人数,
sum(case when 缺勤状态=4 then 1 else 0 end) as 事假人数,
sum(case when 缺勤状态=5 then 1 else 0 end) as 公假人数
from 学生缺勤表
group by 系别