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

sql script

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(product_name) >= 2
                  order by user_id)
and date >= '2025-10-15'
and status='completed'
and product_name in ('C++', 'Java', 'Python')