题解 | #分析客户逾期情况#
分析客户逾期情况
https://www.nowcoder.com/practice/22633632da344e2492973ecf555e10c9
with pay_ability_overdue as(
select pay_ability,overdue_days
from loan_tb a left join customer_tb b on a.customer_id=b.customer_id)
select pay_ability,
concat(round(count(overdue_days)/count(pay_ability)*100,1),'%') as overdue_ratio
from pay_ability_overdue
group by pay_ability
order by overdue_ratio desc
投递百度等公司7个岗位
查看30道真题和解析
刚看到以为是无中生友 一看是你 那没事了 不是无中生友