select B.pay_ability,concat(round(count(CASE WHEN A.overdue_days IS NULL then NULL else 1 end)/count(A.customer_id)*100,1),"%")  as overdue_ratio
from loan_tb A 
left join customer_tb B
on A.customer_id = B.customer_id
group by B.pay_ability
order by overdue_ratio DESC