select pay_ability, concat(format(avg(if(overdue_days is null, 0, 1)) * 100, 1),"%") as overdue_ratio
from loan_tb
join customer_tb using(customer_id)
group by pay_ability
order by overdue_ratio desc