题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select pay_ability,
concat(round(sum(case when overdue_days is not null then 1 else 0 end)/count(l.customer_id)*100,1),'%') as overdue_ratio
from loan_tb l join customer_tb c
on l.customer_id=c.customer_id
group by pay_ability
order by overdue_ratio desc
查看15道真题和解析