题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select
pay_ability,
concat(round(
100.0*(sum(if (overdue_days is not NULL, 1, 0)) / count(*)),1
),'%') overdue_ratio
from
loan_tb t1
left join customer_tb t2 on t1.customer_id = t2.customer_id
group by
pay_ability
order by overdue_ratio desc;
投递顺丰集团等公司8个岗位 >
蔚来公司氛围 335人发布
查看5道真题和解析