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

SELECT id 
      ,is_group_buy
      ,IF(is_group_buy='NO',NAME,NULL) AS client_name
FROM
(SELECT  a.id
        ,user_id
        ,product_name
        ,STATUS
        ,client_id
        ,DATE
        ,is_group_buy
        ,b.id as 客户端id
        ,NAME
        ,COUNT(product_name) OVER(PARTITION BY user_id) AS cnt
FROM order_info AS a LEFT JOIN client AS b
ON a.client_id = b.id
WHERE DATE>='2025-10-15'
AND STATUS = 'completed'
AND product_name IN ('C++','Java','Python')
) AS t1
WHERE cnt>=2
ORDER BY id ASC