select department
,concat(round(sum(case when timestampdiff(second,first_clockin,last_clockin)/60/60>9.5 then 1 else 0 end)/count(*)*100,1),'%') as ratio
from staff_tb t
join attendent_tb t1 on t.staff_id=t1.staff_id
group by department
order by ratio desc