题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
select a.user_id, a.total+a.point as point from( select o.user_id,sum(o.order_price) as total,u.point from order_tb o join uservip_tb u on o.user_id = u.user_id where o.order_price>100 group by o.user_id)a order by point desc
是每笔交易金额大于100，而非总计
