牛客的课程订单分析(三)

击败92，代码相对简洁点

SELECT *
FROM order_info
WHERE user_id IN

(SELECT user_id FROM order_info 
WHERE status='completed' 
AND date>'2025-10-15'
AND product_name IN ('C++','Java','Python')
GROUP BY user_id HAVING COUNT(*)>=2 )
--因为需要查询购买成功2次及以上的，故需要一个子查询使用GROUP BY来查询次数、筛选user_id，而下面重复的约束条件无法避免

AND status='completed' 
AND date>'2025-10-15'
AND product_name IN ('C++','Java','Python')
ORDER BY id ASC