题解 | #牛客的课程订单分析(六)#

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_id = c.id 
where cnt >=2
order by t.id