select
    pay_ability,
    concat(
        round(count(if(overdue_days is not null, 1, null)) * 100 / count(*),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