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

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