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

from order_info o
join
(select a.user_id as u***r /> from (select user_id  from order_info
      where status='completed' and product_name in ('C++','Java','Python')
      and date>'2025-10-15'
      group by user_id
      having count(distinct(product_name))>=2
     ) a) b
on o.user_id=b.u***r /> where product_name in ('C++','Java','Python') and status='completed' and o.date>'2025-10-15'
order by o.id;