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

SELECT user_id
FROM (
    SELECT user_id, COUNT(*) AS COT
    FROM order_info
    WHERE date > '2025-10-15' 
      AND status = 'completed' 
      AND product_name IN ('C++', 'Java', 'Python')
    GROUP BY user_id
    HAVING COUNT(*) >= 2  
) T1
ORDER BY user_id;

SELECT user_id

FROM (

SELECT user_id, COUNT(*) AS COT

FROM order_info

WHERE date > '2025-10-15'

AND status = 'completed'

AND product_name IN ('C++', 'Java', 'Python')

GROUP BY user_id) T1

where COT >=2

ORDER BY user_id;

where不能查询聚合函数