select pay_ability,concat(round(count(overdue_days)/count(*)*100,1),'%') as overdue_ratio
from loan_tb lt
inner join customer_tb ct
on lt.customer_id=ct.customer_id
group by pay_ability
order by overdue_ratio desc