select distinct ut.user_id,point+s as point
from uservip_tb ut,
     (select user_id,sum(if(order_price>100,order_price,0)) as s
        from order_tb
        group by user_id) ot
where ut.user_id = ot.user_id and s > 0
order by point desc ;