题解 | #分析客户逾期情况#
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
sum(if(overdue_days is not null,1,0)) 筛选逾期人数 concat(X...,'%')用于链接X...与% select pay_ability, concat(round(sum(if(overdue_days is not null,1,0))/count(customer_id)*100,1),'%') as overdue_ratio from loan_tb join customer_tb using(customer_id) group by 1 order by 2 desc
明年6月都是99%
