题解 | 统计加班员工占比
统计加班员工占比
https://www.nowcoder.com/practice/6c0a521c36e14c7599eaef858f6f8233
select
st.department,
concat(round(sum(case when timestampdiff(minute , at.first_clockin,at.last_clockin) > 570 then 1 else 0 end )/ count(at.staff_id) * 100 ,1),'%')as ratio
from attendent_tb at
inner join staff_tb st
on st.staff_id = at.staff_id
group by
st.department
order by
ratio desc
简简单单吃个羊头