题解 | 统计加班员工占比
统计加班员工占比
https://www.nowcoder.com/practice/6c0a521c36e14c7599eaef858f6f8233
select department , concat(round((sum(if(timestampdiff(second,first_clockin,last_clockin)/3600 > 9.5, 1,0))/count(department))*100,1),'%') ratio from staff_tb a left join attendent_tb b on a.staff_id= b.staff_id group by department order by ratio desc
