题解 | 分析客户逾期情况

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