题解 | 更新用户积分信息?
更新用户积分信息?
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
select user_id ,point + add_point as point from (select user_id , sum(order_price) as add_point from order_tb where order_price >100 group by user_id ) as o left join uservip_tb u using(user_id) order by point desc
