select a.id,is_group_buy,namefrom (select *,count(id) over(partition by user_id) as cntfrom order_infowhere date>'2025-10-15'and order_info.status="completed"and product_name in ("C++","Java","Python")) as aleft join client c on c.id=a.client_idwhere cnt>...