题解 | 统计各岗位员工平均工作时长
SELECT post, round(avg((TIMESTAMPDIFF(minute,first_clockin,last_clockin)/60)),3) work_hours FROM staff_tb a JOIN attendent_tb b USING(staff_id) GROUP BY post ORDER BY work_hours DESC
SELECT post, round(avg((TIMESTAMPDIFF(minute,first_clockin,last_clockin)/60)),3) work_hours FROM staff_tb a JOIN attendent_tb b USING(staff_id) GROUP BY post ORDER BY work_hours DESC
相关推荐
吴鹏阳:这个老师如果爱举报,你这门课确实可能挂科,这没办法。但是辅导员所谓的延毕,,怎么说呢,毕业生的就业率可是辅导员的一大考核,他咋可能为了一个逃课实习去损害自己的利益呢?