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

select o.id, o.is_group_buy, c.name client_name from order_info o
left join client c
ON
o.client_id=c.id
where o.user_id in
(select user_id from order_info 
 where date>'2025-10-15' and status='completed' and product_name in ('C++', 'Java', 'Python')
 group by user_id
 having count(*)>=2
 )
 and date>'2025-10-15' and status='completed' and product_name in ('C++', 'Java', 'Python')
 order by o.id