题解 | 分析客户逾期情况

SELECT
    pay_ability,
    CONCAT(ROUND((count(overdue_days)/count(*))*100,1),'%') AS overdue_ratio # CONCAT 用于输出百分比
FROM loan_tb
LEFT JOIN customer_tb USING(customer_id) # 左连表
GROUP BY pay_ability
ORDER BY overdue_ratio DESC