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

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