题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
select o.user_id,v.point + sum(order_price) point from order_tb o left join uservip_tb v on o.user_id = v.user_id where order_price > 100 group by o.user_id order by point desc
还有更简洁的代码没？