select pay_ability, 
concat(round(sum(case when overdue_days is not null then 1 else 0 end)/count(1)*100, 1), '%') as overdue_ratio
from loan_tb loan join customer_tb as cus on loan.customer_id=cus.customer_id
group by pay_ability
order by overdue_ratio desc