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

SELECT
    COALESCE(name,'GroupBuy') source,
    COUNT(*) cnt
FROM(
    SELECT
        o.id,
        is_group_buy,
        c.name,
        COUNT(*) OVER (PARTITION BY user_id) cnt
    FROM
        order_info o
    LEFT JOIN
        client c ON o.client_id = c.id
    WHERE
        date > '2025-10-15' AND
        product_name IN ('C++','Python','Java') AND
        status = 'completed'
)t
WHERE
    cnt >= 2
GROUP BY
    source
ORDER BY
    source