题解 | 更新用户积分信息？
更新用户积分信息？
https://www.nowcoder.com/practice/ef1f2fda4338460b948810f3f7e7a68e
SELECT
u.user_id,
u.point + t.add_point AS point
FROM (
SELECT
user_id,
SUM(CASE WHEN order_price > 100 THEN order_price
ELSE 0
END) AS add_point
FROM order_tb
GROUP BY user_id
HAVING add_point > 0) t JOIN uservip_tb u ON t.user_id = u.user_id
ORDER BY point DESC
查看5道真题和解析