select 
pay_ability,
concat(
round(
(
sum(overdue_days is not  null)/count(distinct cb.customer_id))*100,1),"%") as overdue_ratio
from loan_tb tb inner join customer_tb cb 
on tb.customer_id=cb.customer_id
group by pay_ability
order by overdue_ratio desc