题解 | 统计各岗位员工平均工作时长
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
select
post,
avg(timestampdiff(second,first_clockin,last_clockin)/3600) as work_hours
from staff_tb s
left join attendent_tb a
on s.staff_id=a.staff_id
group by post
order by work_hours desc
;
深信服公司福利 839人发布