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