题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select distinct pay_ability,
concat(round(count(overdue_days) over(partition by pay_ability)*100/count(*) over(partition by pay_ability),1),'%') overdue_ratio
from loan_tb l join customer_tb c on l.customer_id = c.customer_id
order by overdue_ratio desc
迅雷公司福利 195人发布