题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
select a.user_id user_id ,point+new_point point from ( select user_id ,sum(order_price) new_point from order_tb where order_price > 100 group by 1 )a left join uservip_tb on a.user_id = uservip_tb.user_id order by point desc
查看20道真题和解析