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

这样比较容易理解！

SELECT * from order_info
WHERE user_id in(
        SELECT user_id
        from order_info

        group by user_id
        HAVING count(*)>=2
)

and `date` > DATE('2025-10-15')
and `status` = 'completed'
and product_name in(
    'C++',
    'Java',
    'Python'
)