with t as (
select
u.user_id
,sum(if(order_price > 100, order_price, 0)) new_point
,point original_point 
from uservip_tb u 
left join order_tb o
on u.user_id = o.user_id
group by u.user_id)
select
user_id,
new_point + original_point point
from t
where new_point > 0
order by point desc