select u.user_id,point+price as point from uservip_tb as u
join
(select user_id, sum(order_price) as price from order_tb
where order_price > 100
group by user_id) as o
on u.user_id = o.user_id
order by point desc