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

select *
from order_info
where 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(user_id) >= 2
                  order by user_id)
  and date > '2025-10-15'
  and status = 'completed'
  and product_name in ('C++', 'Java', 'Python')
order by id;