81,122
社区成员




--假如该段有22个工作ri
select a.userid,a.checkrate,b.late,c.leave,d.absent from
(select userid,count(*)/22 checkdate from manualsign group by userid)a,
(select userid,count(*) late from manualsign where 签到时间<8:30 group by userid )b,
(select userid,count(*) leave from manualsign where 签退时间>8:30 group by userid )c,
(select userid,22-count(*) absentfrom manualsign group by userid )d,
where a.userid=b.userid,b.userid=c.userid,c.userid=d.userid,d.userid=a.userid