select dt, count(*), round(avg(s), 2) from ( select a1.uid, a1.dt, if (a1.dt = a2.dc, 1, 0) as s from ( select uid, dt, if ( datediff ( lead (dt, 1, 0) over ( partition by uid order by dt ), dt ) = 1, 1, 0 ) as df from ( select uid, dt from ( select uid, artical_id, date (in_time) as dt from tb_user...