题解 | 分析客户逾期情况

select t1.pay_ability,concat(round(sum(if(t1.overdue_days is null,0,1))/count(t1.customer_id)*100,1),'%') overdue_ratio
from(
select l.customer_id,l.overdue_days,c.pay_ability
from loan_tb l 
left join customer_tb c
on l.customer_id=c.customer_id
) t1
group by t1.pay_ability
order by overdue_ratio desc;

#方法二
select c.pay_ability,concat(round(sum(if(l.overdue_days is Null,0,1))/count(c.customer_id)*100,1),'%') overdue_ratio
from loan_tb l left join customer_tb c
on l.customer_id=c.customer_id
group by c.pay_ability
order by overdue_ratio desc;