题解 | 统计加班员工占比
统计加班员工占比
https://www.nowcoder.com/practice/6c0a521c36e14c7599eaef858f6f8233
select department, concat(round(count(if(timestampdiff(minute,first_clockin,last_clockin)/60>9.5,1,null))/count(*)*100,1),'%') ratio from staff_tb st join attendent_tb at using(staff_id) group by department order by ratio desc
投递腾讯等公司10个岗位 >
ai做完cv