题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select pay_ability,concat(round((sum(case when overdue_days >0 then 1 else 0 end)/count(case when overdue_days >0 then 1 else 0 end))*100,1),'%') as overdue_ratio from loan_tb l join customer_tb c on l.customer_id = c.customer_id group by pay_ability order by overdue_ratio desc
