题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
with t1 as ( select ct.pay_ability pay_ability ,count(*) count ,sum(if(lt.overdue_days is not null, 1, 0)) num from loan_tb lt inner join customer_tb ct on lt.customer_id = ct.customer_id group by ct.pay_ability) select pay_ability, concat(round(num / count * 100, 1),'%') overdue_ratio from t1 order by overdue_ratio desc
查看17道真题和解析
