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