1、在原表中增加一列按用户id 分组按日期排序;增加一列按用户id分组并计数
select user_id,date, row_number() over(partition by user_id order by date) as rnk, count(status) over (partition by user_id) as cnt from order_info where date>'2025-10-15' and status='completed' and product_name in ('C++','Java','Python')2、在仪表中查询排序rnk=1和计数cnt>=2 的用户信息
select user_id,date as first_buy_date,cnt from (select user_id,date, row_number() over(partition by user_id order by date) as rnk, count(status) over (partition by user_id) as cnt from order_info where date>'2025-10-15' and status='completed' and product_name in ('C++','Java','Python')) as a where rnk=1 and cnt>=2 order by user_id;