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