SELECT user_id, u.point + SUM(order_price) AS point FROM order_tb o LEFT JOIN uservip_tb u USING (user_id) WHERE order_price > 100 GROUP BY user_id ORDER BY point DESC