电商数仓-最近7日内连续3日下单用户数
方案一：select count(distinct(user_id))from( select user_id, datediff(lead2,dt)diff from ( select user_id, dt, lead(dt,2,'9999-12-31') over (partition by user_id order by dt)lead2 f..
