WITH t3 AS( SELECT t2.pay_ability, COUNT(t1.customer_id) cnt_c, SUM(IF(t1.overdue_days IS NULL,0,1)) s_c FROM loan_tb t1,customer_tb t2 WHERE t1.customer_id = t2.customer_id GROUP BY t2.pay_ability ) SELECT t3.pay_ability, CONCAT(ROUND((t3.s_c / t3.cnt_c)*100,1),'%') ov...