題解 | #分析客戶逾期情況#
分析客戶逾期情況
http://fangfengwang8.cn/practice/22633632da344e2492973ecf555e10c9
sum(if(overdue_days is not null,1,0)) 篩選逾期人數(shù) 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
滴滴公司福利 675人發(fā)布
