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

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