题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
select user_id,sum_order_price+point as point
from(
select user_id,sum(order_price) as sum_order_price
from order_tb
where order_price>100
group by user_id
order by user_id
) a
join uservip_tb using(user_id)
order by point desc
投递阿里巴巴等公司10个岗位
深信服一面223人在聊
查看8道真题和解析