with t as(
select 
    user_id,
    sum(order_price) as total_p
    from order_tb
    where order_price > 100
    group by user_id
)

select
u.user_id,
u.point + total_p as point
from uservip_tb u
inner join t
on u.user_id = t.user_id
order by u.point + total_p desc;