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

order by point desc

是每笔交易金额大于100，而非总计