(二)改一改就好了
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