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

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