题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
SELECT
u.user_id,
u.point + SUM(
CASE
WHEN o.order_price > 100
THEN o.order_price
ELSE 0
END
) AS point
FROM uservip_tb u
LEFT JOIN order_tb o ON u.user_id = o.user_id
where o.order_price > 100
GROUP BY u.user_id, u.point
order by point desc
