题解 | 统计各岗位员工平均工作时长
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
select post,round(avg(timestampdiff(minute,a.first_clockin,a.last_clockin))/60,3) as work_hours from staff_tb s join attendent_tb a on s.staff_id = a.staff_id group by s.post order by work_hours desc
美团公司氛围 2508人发布
