题解 | 统计加班员工占比
统计加班员工占比
https://www.nowcoder.com/practice/6c0a521c36e14c7599eaef858f6f8233
select
b.department,
concat(round(sum(if(timestampdiff(second,a.first_clockin,a.last_clockin)/3600 >9.5,1,0)) /
count(distinct a.staff_id)*100,1),'%') as ratio
from
attendent_tb a
left join
staff_tb b on a.staff_id = b.staff_id
group by
1
order by
2 desc;
腾讯云智研发公司福利 128人发布