select user_id,sum_order_price+point as point from( select user_id,sum(order_price) as sum_order_price from order_tb where order_price>100 group by user_id order by user_id ) a join uservip_tb using(user_id) order by point desc