题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
https://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
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
