题解 | 统计加班员工占比
统计加班员工占比
https://www.nowcoder.com/practice/6c0a521c36e14c7599eaef858f6f8233
select department,concat(
round(
(sum(case when timestampdiff(minute,first_clockin,last_clockin)/60>9.5 then 1 else 0 end)/count(a.staff_id))*100,1),'%'
) as ratio
from staff_tb a
left join attendent_tb b
using(staff_id)
group by department
order by ratio DESC
查看14道真题和解析