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