with # 最小登录月份 t1 as (select distinct uid, min(date_format(start_time, '%Y%m')) over(partition by uid) as start_mon from exam_record), # 临时表用作统计新增 t2 as (select distinct uid, date_format(start_time, '%Y%m') as start_month, start_mon from exa...
