题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
select a.user_id,sum(order_price)+b.point as point from order_tb a join uservip_tb b on a.user_id=b.user_id where a.order_price>100 group by a.user_id order by point desc
内连接就是没下单且不是会员的数据都会被剔除
