题解 | #牛客每个人最近的登录日期(六)#

select o.id, is_group_buy, case when is_group_buy ='no' then c.name else null end as client_name from order_info o left join client c on o.client_id=c.id join( SELECT id, count(id)over(partition by user_id)cnt from order_info where date>'2025-10-15' and status='completed' and product_name in('C++','Java','Python') )a on o.id=a.id where cnt>=2 order by o.id