select
        utb.user_id,
        point + total_price as point
from 
        uservip_tb as utb
left join (
    select
        user_id,
        sum(order_price) total_price
    from 
            order_tb
    where 
            order_price > 100
    group by
            user_id
)a
on 
        utb.user_id = a.user_id
where
        total_price is not null
order by 
        point desc