题解 | #分析客户逾期情况#
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select pay_ability,concat(round((sum(case when overdue_days is null then 0 else 1 end)/count(t1.customer_id))*100,1),'%') overdue_ratio from loan_tb t1 join customer_tb t2 on t1.customer_id=t2.customer_id group by pay_ability order by overdue_ratio desc;
查看1道真题和解析