题解 | 分析客户逾期情况
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
select pay_ability
,concat(round((100*overid_num/total_num),1),"%") overdue_ratio
from(
select pay_ability
,count(overdue_days) as overid_num
,count(*) as total_num
from customer_tb c left join loan_tb l on c.customer_id=l.customer_id
group by pay_ability) as num
order by overdue_ratio desc
查看26道真题和解析