看了一下 俺的代码比较取巧select user_id,min(date),substr(group_concat(distinct(date)order by date ), 12, 10) ,count(user_id) cntfrom order_info where date>'2025-10-15' and product_name in ('Python', 'C++', 'Java') and status='completed'group by user_idhaving(count(user_id))>1order by user_id; 其他部分没啥好说subs...