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