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

分析客户逾期情况

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


select 
pay_ability,
concat(
round(
(
sum(overdue_days is not  null)/count(distinct cb.customer_id))*100,1),"%") as overdue_ratio
from loan_tb tb inner join customer_tb cb 
on tb.customer_id=cb.customer_id
group by pay_ability
order by overdue_ratio desc

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务