题解 | 分析客户逾期情况

with base as (select ct.pay_ability, lt.customer_id, lt.overdue_days
              from loan_tb lt
                       left join customer_tb ct on lt.customer_id = ct.customer_id),
     khs as (select pay_ability, count(customer_id) as zkhs, count(overdue_days) yqkhs from base group by pay_ability)
select pay_ability,concat(round(round(yqkhs/zkhs,3)*100,1),'%') as overdue_ratio
from khs order by overdue_ratio desc