题解 | 统计各岗位员工平均工作时长
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
select post ,round(avg(worktime),3) work_hours FROM( select post ,round(TIMESTAMPDIFF(minute,first_clockin,last_clockin)/60,3) as worktime from attendent_tb a join staff_tb s on a.staff_id = s.staff_id ) as wk group by post order by work_hours desc
