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

with a1 as (
select o.user_id,v.point,sum(if(order_price > 100 ,order_price,0)) aa
from order_tb o  join uservip_tb v on o.user_id = v.user_id
group by user_id)
select user_id,(point+aa) point
 from a1 
  where aa > 0
 order by point desc;