题解 | 统计各岗位员工平均工作时长
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
SELECT
s.post,
ROUND(
AVG(TIMESTAMPDIFF(SECOND,first_clockin,last_clockin)) / 3600
,3) AS work_hours
FROM attendent_tb AS a
INNER JOIN staff_tb AS s
ON (a.staff_id = s.staff_id)
WHERE first_clockin IS NOT NULL
AND last_clockin IS NOT NULL
GROUP BY s.post
ORDER BY work_hours DESC;
OPPO公司福利 1229人发布