大永特烦恼：第四种写法也是错误的,首先语法就是错误的,select所筛选的列,除了是常数(列如'黎明' as name)这种外,都必须放在group by后面,可以修改成如下 select a.user_id, a.first_buy_date, a.second_buy_date, a.cnt from (select user_id, min(date) over(partition by user_id) as first_buy_date, lead(date,1,0) over(partition by user_id order by date) as second_buy_date, row_number() over(partition by user_id order by date) as rn, count(*) over(partition by user_id) as cnt from order_info where date>='2025-10-16' and status='completed' and product_name in('C++','Java','Python') ) a where a.cnt>=2 and rn=1 order by user_id;