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

分析客户逾期情况

https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9

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

全部评论

相关推荐

点赞 评论 收藏
分享
点赞 收藏 评论
分享
牛客网
牛客企业服务