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

就用上一题找到的ID作为临时表

SELECT * FROM order_info
WHERE user_id IN (SELECT user_id
    FROM order_info
    WHERE product_name in('C++','JAVA','Python')
    and status ='completed'
    and date>'2025-10-15'
    GROUP BY user_id
    HAVING count(status)>=2
    order by user_id)
AND product_name in('C++','JAVA','Python')
    and status ='completed'
    and date>'2025-10-15'