SELECT id,is_group_buy , name
client_name FROM
(SELECT ,COUNT() OVER (PARTITION BY user_id) rn
FROM
(
SELECT o.* ,c.name
FROM order_info o
LEFT JOIN
client
c
ON o.client_id
=c.id) a
WHERE STATUS='completed'
AND DATE > '2025-10-15'
AND product_name IN ('c++','java','python')) b
WHERE rn>1
ORDER BY id ASC