题解 | 统计各岗位员工平均工作时长
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
select
post,
avg(
timestampdiff (second, first_clockin, last_clockin) / 3600
) work_hours
from
staff_tb s
join attendent_tb a on s.staff_id = a.staff_id
group by
post
order by
work_hours desc
投递科锐国际等公司8个岗位