select pay_ability, concat(format(count(overdue_days)/count(pay_ability)*100,1),'%') as overdue_ratio from customer_tb c inner join loan_tb l on c.customer_id=l.customer_id group by pay_ability order by overdue_ratio desc