题解 | 分析客户逾期情况
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
查看1道真题和解析