select id, user_id, product_name, status, client_id, date
from (
    select *, count(id) over(partition by user_id) as cnt
    from order_info 
    where datediff(date,"2025-10-15")>0
      and status ="completed"
      and product_name in ("C++","Java","Python")
) x
where x.cnt > 1
order by x.id