题解 | #牛客的课程订单分析(六)#
牛客的课程订单分析(六)
https://www.nowcoder.com/practice/c5736983c322483e9f269dd23bdf2f6f
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
