题解 | 统计加班员工占比

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

简简单单吃个羊头