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

/*
SELECT user_id
FROM order_info
where date > '2025-10-15' and product_name in ('C++', 'Java', 'Python')
and status = 'completed'
GROUP BY user_id
having count(*) >= 2
order by id;
*/
SELECT *
FROM order_info as info
where date > '2025-10-15' and user_id in(SELECT user_id
FROM order_info
where date > '2025-10-15' and product_name in ('C++', 'Java', 'Python')
and status = 'completed'
GROUP BY user_id
having count(*) >= 2
order by id)
and status = 'completed' and product_name in ('C++', 'Java', 'Python')
order by id;