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

with A as ( select * from order_info where date > '2025-10-15' and product_name in ('C++','Java','Python') and user_id in (select user_id from ( select user_id ,count(product_name) from order_info where date > '2025-10-15' and product_name in ('C++','Java','Python') and status = 'completed' group by 1 having count(product_name) > 1 )a ) and status = 'completed' )

select A.id ,A.is_group_buy ,c.name client_name from A left join client c on A.client_id = c.id order by A.id