题解 | 更新用户积分信息？

select
	t.user_id,
	t.newpoint+t.point as point
from
	(select
		o.user_id,
		sum(o.order_price) as newpoint,
		u.point
	from
    	order_tb o
    left join 
        uservip_tb u 
    on 
        o.user_id=u.user_id
	where
    	o.order_price>100
    group by 
		o.user_id,u.point) t
group by t.user_id,t.newpoint,t.point
order by point desc;