题解 | 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;
正浩创新EcoFlow公司福利 272人发布