with new_user_log as ( select uid, min(in_time) signin_time from tb_user_log group by uid ) , activity_log as ( select uid, date(in_time) dt from tb_user_log union select uid, date(out_time) dt from tb_user_log ) ,t1 as ( select a1.uid, a1.dt, if((a1.dt=date(n1.signin_time)), 1, 0) flag from activit...
