题解 | 统计各岗位员工平均工作时长
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
# timestampdiff(unit,begin,end) select post, avg(timestampdiff(minute, first_clockin, last_clockin)/60) work_hours from staff_tb a inner join attendent_tb b on a.staff_id = b.staff_id group by post order by work_hours desc;
滴滴公司福利 637人发布
投递哈工大机器人集团等公司7个岗位 >