題解 | 分析客戶(hù)逾期情況
分析客戶(hù)逾期情況
http://fangfengwang8.cn/practice/22633632da344e2492973ecf555e10c9
SELECT
pay_ability,
CONCAT(ROUND(SUM(is_overdue)*100.0/COUNT(*), 1), '%') AS overdue_ratio
FROM (
SELECT
c.pay_ability,
MAX(CASE WHEN l.overdue_days > 0 THEN 1 ELSE 0 END) AS is_overdue
FROM customer_tb c
JOIN loan_tb l ON c.customer_id = l.customer_id
GROUP BY c.customer_id
) t
GROUP BY pay_ability
ORDER BY overdue_ratio DESC;
大部分題解考慮的都是 合同占比，而不是 客戶(hù)占比 。
如果一個(gè)客戶(hù)不止一個(gè)合同，答案就會(huì)出錯(cuò)。
查看19道真題和解析
