题解 | #分析客户逾期情况#

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