select xx.channel_type,round(xx.cnt2-xx.cnt1,4) as cn from ( select x.channel_type,sum(case when x.dt='20180707' then 1 else 0 end )/count(distinct case when x.dt='20180707' then x.uid else null end) as cnt1, sum(case when x.dt='20180708' then 1 else 0 end )/count(distinct case when x.dt='2018070...