题解 | #分析客户逾期情况#
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select pay_ability, concat( round( ( sum(overdue_days is not null)/count(distinct cb.customer_id))*100,1),"%") as overdue_ratio from loan_tb tb inner join customer_tb cb on tb.customer_id=cb.customer_id group by pay_ability order by overdue_ratio desc