题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select pay_ability, concat(Round(100*sum(overdue_days is not null)/count(1), 1) , '%') as overdue_ratio from( select t1.customer_id, t1.overdue_days, t2.pay_ability from loan_tb as t1 inner join customer_tb as t2 on t1.customer_id = t2.customer_id) as t3 group by pay_ability order by overdue_ratio desc;
投递知乎等公司10个岗位
手写数字识别就是一个作业而已