题解 | 更新用户积分信息？

   
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