WITH temp AS ( SELECT uid, MAX(DATE(out_time)) max_dt, MIN(DATE(in_time)) new_dt, MAX(MAX(DATE(out_time)))OVER() now_dt FROM tb_user_log GROUP BY uid ), temp1 AS ( SELECT CASE WHEN DATEDIFF(now_dt,new_dt)<=6 THEN '新晋用户' WHEN DATEDIFF(now_dt,max_dt)<...