WITH TMP AS ( SELECT B.*, case when LAST_DAY_TIME is null then 'Y' else 'N' end as is_new -- 如果上次活跃日期为空则是新用户 FROM ( SELECT UID, IN_TIME, LAG(IN_TIME...