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

select t.id,is_group_buy,name client_name
from client c right join
(
select *,count(*)over(partition by user_id) cnt
from order_info
where date > 2025-10-15  
and product_name in ("C++","Python","Java")
and status="completed")t on t.client_id=c.id
where t.cnt>=2
order by t.id

# select *,count(*)over(partition by product_name) cnt
# from order_info
# where date > 2025-10-15  
# and product_name in ("C++","Python","Java")
# and status="completed"