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

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