题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select pay_ability, concat(round((count(overdue_days)/count(*))*100,1), '%') as overdue_ratio from customer_tb join loan_tb Using (customer_id) group by pay_ability order by count(overdue_days)/count(*) desc

