题解 | #牛客的课程订单分析(三)#
牛客的课程订单分析(三)
https://www.nowcoder.com/practice/4ae8cff2505f4d7cb68fb0ec7cf80c57
SELECT order_info.* FROM ( SELECT * FROM order_info WHERE date > '2025-10-15' AND status = 'completed' AND product_name IN ('C++','Java','Python') ) AS order_info JOIN ( SELECT DISTINCT user_id FROM order_info WHERE date > '2025-10-15' AND status = 'completed' AND product_name IN ('C++','Java','Python') GROUP BY user_id HAVING COUNT(*) >= 2 ) AS user_info ON order_info.user_id = user_info.user_id