题解 | #分析客户逾期情况#
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
WITH t AS (
SELECT l.*, c.pay_ability
FROM loan_tb AS l
JOIN customer_tb AS c ON c.customer_id = l.customer_id
)
SELECT pay_ability,
CONCAT(ROUND(COUNT(overdue_days) * 100 / COUNT(customer_id), 1),'%') AS overdue_ratio
FROM t
GROUP BY pay_ability
ORDER BY overdue_ratio DESC;
