题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select ct.pay_ability, concat(round(100*count(distinct case when lt.overdue_days is not Null then lt.customer_id end)/count(distinct lt.customer_id),1),'%') as overdue_ratio from customer_tb as ct left join loan_tb as lt on ct.customer_id =lt.customer_id group by pay_ability order by overdue_ratio desc
