题解 | 分析客户逾期情况

select
    ct.pay_ability,
    concat (
        round(
            sum(if (lt.overdue_days > 0, 1, 0)) / count(lt.agreement_id) * 100,
            1
        ),
        '%'
    ) as overdue_ratio
from
    loan_tb as lt
    left join customer_tb as ct on lt.customer_id = ct.customer_id
group by
    ct.pay_ability
order by
    overdue_ratio desc