SELECT pay_ability, CONCAT(ROUND(SUM(od)/COUNT(customer_id)*100,1),'%') overdue_ratio FROM (SELECT lt.customer_id, pay_ability, IF(overdue_days IS NULL,0,1) od FROM loan_tb lt JOIN customer_tb ct ON lt.customer_id = ct.customer_id )t1 GROUP BY pay_ability ORDER BY...