在子查询里按题目要求限制字段并增加一个根据user_id分组的count字段。然后从子查询里获取所需字段并限制count大于等于2.
select t.id, t.user_id, t.product_name,
t.status, t.client_id, t.date
from
(select *, count(id) over (partition by user_id) as cnt
from order_info
where (product_name = "Java" or product_name = "Python" or
product_name = "C++") and
date > "2025-10-15" and status = "completed") as t
where t.cnt >= 2
order by t.id