题解 | 更新用户积分信息?
更新用户积分信息?
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
with order_vip as( select user_id ,sum(order_price) point_new from order_tb where order_price > 100 group by 1 ) select order_vip.user_id ,(point_new+point) point from order_vip left join uservip_tb on order_vip.user_id = uservip_tb.user_id order by 2 desc