题解 | #统计各岗位员工平均工作时长#
统计各岗位员工平均工作时长
https://www.nowcoder.com/practice/b7220791a95a4cd092801069aefa1cae
select post,round(avg(timestampdiff(minute,first_clockin,last_clockin))/60,3) work_hours from staff_tb t1 join attendent_tb t2 on t1.staff_id=t2.staff_id where first_clockin is not null and last_clockin is not null group by post order by work_hours desc; #答案错误，错哪了？-以小时为单位，不是以小时为差
学而思开奖121人在聊
