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

SELECT order_info.* FROM order_info
JOIN
(SELECT user_id, COUNT(*) count FROM order_info
WHERE date > '2025-10-15' AND status = 'completed'
AND product_name IN ('C++', 'Python', 'Java')
GROUP BY user_id) t
ON order_info.user_id = t.user_id
WHERE t.count >= 2
AND date > '2025-10-15' AND status = 'completed'
AND product_name IN ('C++', 'Python', 'Java')
ORDER BY id;