题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
http://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
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
小米集团公司氛围 378人发布
投递大连飞创信息技术有限公司等公司10个岗位