select t.id,is_group_buy,name as client_name from ( select id,is_group_buy,client_id,count(*)over(partition by user_id) as cnt from order_info where date > '2025-10-15' and product_name in ('C++', 'Python', 'Java') and status = 'completed' )t left join client c on t.client_i...
