题解 | #统计各岗位员工平均工作时长#
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
select post, round(avg(timestampdiff(second,b.first_clockin,b.last_clockin) / 3600),3) as work_hours from staff_tb a join attendent_tb b on a.staff_id=b.staff_id where b.first_clockin is not null and b.last_clockin is not null group by post order by work_hours desc;
查看12道真题和解析