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