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

with order_info_2 AS (
    SELECT * FROM order_info
WHERE user_id IN (
    SELECT a.user_id
    FROM (
        SELECT *
        FROM order_info
        WHERE date > '2025-10-15' AND status = 'completed' AND product_name IN ('C++', 'Python','Java')
    ) a
    GROUP BY a.user_id
    HAVING COUNT(*) >= 2
)
AND date > '2025-10-15' AND status = 'completed' AND product_name IN ('C++', 'Python','Java')
)
select user_id ,min(date) as first_buy_date ,count(user_id) as cnt from order_info_2 
group by user_id 
order by user_id