题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select
ct.pay_ability as pay_ability,
CONCAT(round(sum(case when lt.overdue_days is not null then 1 else 0 end) / count(*)*100,1),'%') as overdue_ratio
from
loan_tb lt
join
customer_tb ct on lt.customer_id = ct.customer_id
group by
ct.pay_ability
order by
overdue_ratio desc
- 先连表
- 再分组
- 后排序
- 最后选择
