题解 | 统计加班员工占比
统计加班员工占比
https://www.nowcoder.com/practice/6c0a521c36e14c7599eaef858f6f8233
select department ,concat(round(sum(case when timestampdiff(second,first_clockin,last_clockin)/60/60>9.5 then 1 else 0 end)/count(*)*100,1),'%') as ratio from staff_tb t join attendent_tb t1 on t.staff_id=t1.staff_id group by department order by ratio desc
