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