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