在上个题目的答案下在套娃就行


select o.id, o.user_id, o.product_name, o.status, o.client_id, o.date
from order_info o
join
(select a.user_id as u***r /> from (select user_id  from order_info
      where status='completed' and product_name in ('C++','Java','Python')
      and date>'2025-10-15'
      group by user_id
      having count(distinct(product_name))>=2
     ) a) b
on o.user_id=b.u***r /> where product_name in ('C++','Java','Python') and status='completed' and o.date>'2025-10-15'
order by o.id;