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

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