考勤系统统计sql问题

checkInOut     打卡记录表     userId（关联userInfo表主键）      checktime 打卡时间         
                                             1                  2012-7-22 17:58:08
                                             1                  2012-7-23 17:38:36
                                             1                  2012-7-24 8:00:00
                                             1                  2012-7-24 17:55:47
                                             2                  2012-7-22 17:58:08
                                             2                  2012-7-23 17:38:36
                                             2                  2012-7-24 17:55:11
                                             3                  2012-7-23 17:38:36
                                             3                  2012-7-24 17:54:43
                                             4                  2012-7-24 17:59:55
num_run_deil   班次表      num_runid主键    starttime    endtime       sdays     edays
                                9           8:30:00      11:30:00       1          1
                                9           14:00:00     18:00:00       1          1
                                9           8:30:00      11:30:00       2          2
                                9           14:00:00     18:00:00       2          2
                                9           8:30:00      11:30:00       3          3
                                9           14:00:00     18:00:00       3          3
userInfo       人员表      userId主键  name    gender   title
                                1      张三     男      工程师
                                2      李四     男      领导
                                3      小红     女      前台
                                4      小磊     男      程序员我想统计一下谁，迟到、早退、应到、矿工、请假的次数