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

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