题解 | #统计各岗位员工平均工作时长#
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
select post, avg(timestampdiff(second,first_clockin,last_clockin))/3600 as work_hours from staff_tb sb inner join attendent_tb ab on sb.staff_id=ab.staff_id group by post order by work_hours desc
查看7道真题和解析
