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

#直接窗口函数就可以
# select id,user_id,product_name, status, client_id, date
# from
# (
# select *,
# count(user_id)over(partition by user_id) count
# from order_info
# where date >= '2025-10-15'
# and status = 'completed'
# and product_name in ('C++','Java','Python')
# ) b
# where count >= 2 
# order by id


# HAVING COUNT(id) >= 2 可以用 但是复杂
select*
from order_info
where user_id in
(
select user_id
from order_info
where date >= '2025-10-15'
and status = 'completed'
and product_name in ('C++','Java','Python')
group by user_id
HAVING COUNT(id) >= 2
)
and date >= '2025-10-15'
and status = 'completed'
and product_name in ('C++','Java','Python')
order by id