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

SELECT user_id,min(date) as first_buy_date,count(product_name) as cnt from order_info where user_id in (select distinct user_id from order_info where product_name in('Java','Python','C++') and DATE_FORMAT(date,'%Y-%m-%d') > '2025-10-15' and status = 'completed' group by user_id having COUNT(product_name)>=2) and product_name in('Java','Python','C++') and DATE_FORMAT(date,'%Y-%m-%d') > '2025-10-15' and status = 'completed' group by user_id order by user_id