题解 | 统计各岗位员工平均工作时长
select
st.post,
round(
avg(
timestampdiff (second, att.first_clockin, att.last_clockin) / 3600
),
3
) work_hours
from
test.staff_tb st
join test.attendent_tb att on st.staff_id = att.staff_id
where
att.first_clockin is not null
and att.last_clockin is not null
group by
st.post
order by
work_hours desc
投递美团等公司10个岗位