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