题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select B.pay_ability,concat(round(count(CASE WHEN A.overdue_days IS NULL then NULL else 1 end)/count(A.customer_id)*100,1),"%") as overdue_ratio from loan_tb A left join customer_tb B on A.customer_id = B.customer_id group by B.pay_ability order by overdue_ratio DESC
