题解 | 分析客户逾期情况

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),'%') overdue_ratio
FROM t3
ORDER BY overdue_ratio DESC;