题解 | 分析客户逾期情况

select pay_ability, concat(Round(100*sum(overdue_days is not null)/count(1), 1) , '%') as overdue_ratio from(
select t1.customer_id, t1.overdue_days, t2.pay_ability from loan_tb as t1
inner join
customer_tb as t2
on t1.customer_id = t2.customer_id) as t3
group by pay_ability
order by overdue_ratio desc;