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