题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
with temp as (select user_id,sum( order_price) as add_point from order_tb where order_price>100 group by user_id) select t.user_id,add_point+point as point from temp t join uservip_tb u on u.user_id=t.user_id order by point desc;