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