题解 | 分析客户逾期情况

select
    pay_ability,
    concat(
        round(
            100 * sum(
                case
                    when overdue_days is not null then 1
                    else 0
                end
            ) / count(distinct p1.customer_id),
            1
        ),
        '%'
    ) as overdue_ratio
from
    loan_tb as p1
    inner join customer_tb as p2 on p1.customer_id = p2.customer_id
group by
    pay_ability
order by
    overdue_ratio desc;