题解 | 统计各岗位员工平均工作时长

select s.post,
round(avg(timestampdiff(second,first_clockin,last_clockin)/3600),3) as work_hours 
from staff_tb s
left join attendent_tb a
on s.staff_id = a.staff_id
group by s.post
order by work_hours desc;