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

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