with
t1 as(
    select
        user_id,
        sum(if(order_price>100,order_price,0)) as add_point
    from
        order_tb
    where
        order_price>100
    group by
        user_id
)
,t2 as(
    select
        user_id,
        add_point + point as point
    from
        t1 left join uservip_tb using(user_id)
    order by
        point desc
)

select * from t2