select id,is_group_buy,if(is_group_buy='yes',null,client_name) client_name from (select o.id,o.client_id,is_group_buy,name client_name,count(user_id)over(partition by user_id) cnt from order_info o left join client c on o.client_id=c.id where date >'2025-10-15' and product_name in("c++","python",...
