题解 | 统计各岗位员工平均工作时长
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
select post ,sum(timestampdiff(minute,a.first_clockin,a.last_clockin)/60.0)/count(distinct s.staff_id) as work_hours from staff_tb s join attendent_tb a on s.staff_id = a.staff_id where a.first_clockin is not null and a.last_clockin is not null group by 1 order by work_hours desc
时间差函数函数
这世界真是越来越看不明白
，让我扣2办理