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