select department,concat(round(sum(if(timestampdiff(second,first_clockin,last_clockin)/60/60>9.5,1,0))/count(distinct b.staff_id)*100,1),'%') ratio
from staff_tb a join attendent_tb b on a.staff_id = b.staff_id
group by department
order by ratio desc