让ai来写#牛客的课程订单分析(六)#

SELECT
    o.id,
    o.is_group_buy,
    IF(o.is_group_buy = 'Yes', NULL, c.name) AS client_name
FROM
    order_info o
    left JOIN client c ON o.client_id = c.id
WHERE
    o.date > '2025-10-15' AND
    o.status = 'completed' AND
    o.product_name IN ('C++', 'Java', 'Python') AND
    o.user_id IN (
        SELECT
            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(DISTINCT product_name) >= 2
    )
ORDER BY
    o.id ASC;