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