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

select
    pay_ability,
    concat (
        round(avg(if (overdue_days is null, 0, 1) )* 100, 1),
        '%'
    ) as overdue_ratio
from
    loan_tb l
    inner join customer_tb c on c.customer_id = l.customer_id
group by
    pay_ability
order by
    overdue_ratio desc