select user_id ,point + add_point as point from (select user_id , sum(order_price) as add_point from order_tb where order_price >100 group by user_id ) as o left join uservip_tb u using(user_id) order by point desc