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

WITH info AS (
SELECT
    id
    , user_id
    , product_name
    , status
    , client_id
    , date
    , COUNT(1) over(PARTITION BY user_id) cnt
    , is_group_buy
FROM order_info
WHERE date >='2025-10-15'
    AND product_name IN ('C++','Python','Java')
    AND status = 'completed'
)
SELECT
    i.id
    , is_group_buy
    , name client_name
FROM info i
    LEFT JOIN client c
        ON i.client_id = c.id
            AND i.is_group_buy = 'No'
WHERE cnt >= 2
ORDER BY i.id

！左连接