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