题解 | SQL278 牛客的课程订单分析(三)

WITH t1 AS (
    SELECT 
        id,
        user_id,
        product_name,
        status,
        client_id,
        date
    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 buy_count
    FROM t1
    GROUP BY user_id
),
t3 AS (
    SELECT 
        id
    FROM t1
    WHERE user_id IN (SELECT user_id FROM t2 WHERE buy_count >= 2)
),
t4 AS (
    SELECT *
    FROM t1
    WHERE id IN (SELECT id FROM t3)
    ORDER BY id ASC
)
SELECT * FROM t4;

# 记得进行筛选购买次数大于2的数据！