题解 | 统计各岗位员工平均工作时长
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
SELECT post, AVG(ROUND(TIMESTAMPDIFF(second, first_clockin, last_clockin)/3600, 3)) work_hours FROM staff_tb s JOIN attendent_tb a ON s.staff_id = a.staff_id WHERE first_clockin IS NOT NULL AND last_clockin IS NOT NULL GROUP BY post ORDER BY work_hours DESC
查看20道真题和解析