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