(二)改一改就好了
SELECT user_id,min(date),count(product_name) FROM order_info WHERE product_name in('C++','JAVA','Python') and status ='completed' and date>'2025-10-15' GROUP BY user_id HAVING count(status)>=2 order by user_id
(二)改一改就好了
SELECT user_id,min(date),count(product_name) FROM order_info WHERE product_name in('C++','JAVA','Python') and status ='completed' and date>'2025-10-15' GROUP BY user_id HAVING count(status)>=2 order by user_id