题解 | #分析客户逾期情况#
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
WITH overdue AS(
SELECT *,
CASE
WHEN overdue_days IS NOT NULL THEN 1
ELSE 0
END AS overdue_num
FROM loan_tb
)
SELECT ct.pay_ability,
concat(ROUND(AVG(overdue.overdue_num) * 100, 1), '%') AS overdue_ratio
FROM customer_tb AS ct
LEFT JOIN overdue
ON ct.customer_id = overdue.customer_id
GROUP BY ct.pay_ability
ORDER BY overdue_ratio DESC;
查看14道真题和解析
