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