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