题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
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
