题解 | 分析客户逾期情况

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 overdue_ratio DESC