select a.user_id user_id
,point+new_point point 
from 
(
	select user_id
	,sum(order_price) new_point
	from order_tb
	where order_price > 100
	group by 1
)a 
left join uservip_tb
on a.user_id = uservip_tb.user_id

order by point desc