select pay_ability, concat(round(avg(if(overdue_days is null, 0, 1)) * 100, 1), '%') overdue_ratio
from customer_tb c
         join
     loan_tb lt on c.customer_id = lt.customer_id
group by pay_ability
order by overdue_ratio desc;