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

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