题解 | SQL279 牛客的课程订单分析(四)
WITH t1 AS (
SELECT *
FROM order_info
WHERE date > '2025-10-15'
AND status = 'completed'
AND product_name IN ('C++','Python','Java')
),
t2 AS (
SELECT
user_id,
min(date) AS first_buy_date,
COUNT(user_id) AS cnt
FROM t1
GROUP BY user_id
)
SELECT * FROM t2
WHERE cnt >= 2
ORDER BY user_id ASC;
查看24道真题和解析