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

select 
post,
avg(timestampdiff(second,first_clockin,last_clockin))/3600 as work_hours
from staff_tb sb inner join attendent_tb ab 
on sb.staff_id=ab.staff_id
group by post
order by work_hours desc