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

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