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

select user_id
from 
(select user_id,sum(case status when 'completed' then 1 else 0 end)completedNum from
order_info where date>'2025-10-15'  and product_name in ('C++','Python','Java')
group by user_id
)t1
where completedNum>=2
order by user_id