SELECT pay_ability,
       CONCAT(ROUND(COUNT(IF(overdue_days IS NOT NULL, overdue_days, NULL)) / COUNT(1) * 100, 1), '%') AS overdue_ratio
FROM loan_tb l
         JOIN customer_tb c ON l.customer_id = c.customer_id
GROUP BY pay_ability
ORDER BY overdue_ratio DESC;