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

with tmp as (select user_id from (select * from order_info where
(product_name = 'C++' OR product_name = 'Java' or product_name = 'Python') and date > '2025-10-15' and status = 'completed') t
group by user_id
having count(*) >= 2
order by user_id asc
)
select * from order_info 
where(product_name = 'C++' OR product_name = 'Java' or product_name = 'Python') and date > '2025-10-15' and status = 'completed' and user_id in (select user_id from tmp)
order by id asc

啰嗦的题目，但是学到了group by的局限性，比如 select id, count(*) from info group by id，那么这样之后就只有这两个了，要访问其它信息会报错，比如 info里面有product列，那么就不能访问了