select pay_ability, concat(round(sum(overdue_days is not null) / count(distinct lt.customer_id) * 100, 1), '%') overdue_ratio from loan_tb lt join customer_tb ct on lt.customer_id = ct.customer_id group by pay_ability order by overdue_ratio desc