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

# 内表找出user_id，外表找出该user_id符合的记录。
with t as
(
    select user_id
    from order_info
    where datediff(date,"2025-10-15") > 0
          and status = "completed"
          and product_name in ("C++","Java","Python")
    group by user_id
    having count(id)>=2
)

select *
from order_info
where user_id in (select * from t)
      and datediff(date,"2025-10-15") > 0
      and status = "completed"
      and product_name in ("C++","Java","Python")
order by id