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