select
    a.user_id,
    b.point + a.point as point
from
    (select
        user_id,
        sum(order_price) as point
    from
        order_tb
    where 
        order_price > 100
    group by 
        user_id) a
left join
    uservip_tb b on a.user_id = b.user_id
order by
    2 desc