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

select distinct user_id,sum(n1) over (partition by user_id) as point
from (
    select ut.user_id,sum(order_price) as n1
    from order_tb join uservip_tb ut on order_tb.user_id = ut.user_id
    where order_price>100
    group by ut.user_id
    union
    select ut.user_id,point
     from order_tb join uservip_tb ut on order_tb.user_id = ut.user_id
    where order_price>100
    group by ut.user_id, point
     ) as t
order by  point desc