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

select a.user_id from 
(select user_id,count(user_id) as numu,sum(case when status='completed' then 1 else 0 end) as nums
      from order_info where product_name in ('c++','java','python') and date >'2025-10-15'
      group by user_id,status) as a 
      where a.numu>=2 and a.nums>=2
order by a.user_id asc