题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select c.pay_ability,
# 当 overdue_days 为 NULL（未逾期）时，结果为 0（非 NULL），也会被 COUNT() 统计,所有设置null
concat(round(count(if(overdue_days is not null,1,null))/count(l.customer_id) *100,1),'%') as overdue_ratio
from loan_tb l
inner join customer_tb c on l.customer_id=c.customer_id
group by c.pay_ability
order by overdue_ratio desc
查看22道真题和解析
