笨办法SELECT user_id, first_buy_date, SUM(cnt)FROM ( SELECT user_id, min(date) over(partition by user_id ) as first_buy_date, count(user_id) as cnt FROM order_info WHERE date > '2025-10-15' AND status = 'completed' AND user_id IN ( SELECT user_id FROM(SELECT user_id, COUNT(product_name) AS DC1 FROM order_info WHERE date > DATE("2025-10-15") AND status = 'completed' AND product_name IN ('C++', 'Java', 'Python') GROUP BY user_id order by user_id ) AS GJJJ WHERE GJJJ.DC1 >= 2 ) AND product_name IN ('C++','Java','Python') group by user_id,date order by user_id ) AS KLLGROUP BY user_id, first_buy_date 我已经通过这道题! https://www.nowcoder.com/questionTerminal/c93d2079282f4943a3771ca6fd081c23