方法一：

with base_tb as (
select user_id,sum(order_price) as point_add
from 
(
select o.user_id,order_price
from order_tb o inner join uservip_tb u on o.user_id = u.user_id
where order_price > 100) t1
group by user_id)


select b.user_id,point+point_add as point
from
base_tb b inner join uservip_tb u on b.user_id = u.user_id
order by point desc