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

select
    user_id,
    min(date) first_buy_date,
    count(id) cnt
from
    (
        select
            *
        from
            order_info
        where
            date > '2025-10-15'
            and status = 'completed'
            and product_name in ('C++', 'Java', 'Python')
    ) t
group by user_id
having count(id) >= 2
order by user_id