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

select a.id, a.is_group_buy,client.name client_name from (select id, is_group_buy, client_id from order_info where 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(user_id)>=2) and date >= '2025-10-15' and status= 'completed' and product_name in ('C++', 'Java', 'Python')) a left join client on a.client_id=client.id