题解 | #牛客的课程订单分析(二)#
牛客的课程订单分析(二)
http://www.nowcoder.com/practice/4ca4137cb490420cad06d2147ae67456
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
太有价值了