题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select pay_ability, CONCAT(TRUNCATE(overdue_ratio, 1), '%') AS overdue_ratio from (select ct.customer_id,pay_ability,round(count(overdue_days)over(partition by pay_ability)*100/count(1) over(partition by pay_ability),1) as overdue_ratio from customer_tb ct left join loan_tb lt on ct.customer_id = lt.customer_id) a group by 1,2 order by overdue_ratio desc#我的秋招日记##硬件开发岗知多少##入职跑路最快的一次经历#