题解 | SQL277 牛客的课程订单分析(二)

WITH t1 AS (
    SELECT 
        user_id
    FROM order_info
    WHERE date > '2025-10-15'
    AND status = 'completed'
    AND product_name IN ('C++','Python','Java')
),
t2 AS (
    SELECT 
        user_id,
        COUNT(user_id) AS num
    FROM t1
    GROUP BY user_id
    HAVING COUNT(user_id) >= 2
)
SELECT user_id FROM t2
ORDER by user_id;