题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
SELECT
o.user_id,
point + SUM(order_price) AS point
FROM order_tb o
JOIN uservip_tb u
ON o.user_id = u.user_id
WHERE order_price > 100
GROUP BY o.user_id
ORDER BY point DESC
投递七牛云等公司10个岗位