题解 | #牛客的课程订单分析(二)#
牛客的课程订单分析(二)
https://www.nowcoder.com/practice/4ca4137cb490420cad06d2147ae67456
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
投递奥马冰箱等公司9个岗位 >