石家庄网站建设咨询_网络营销方式与工具有哪些_微墨小程序制作平台_成都广告制作厂家

drop table dw_htpercent_d;

create table dw_htpercent_d(day string,ht_percent float);

Insert into table dw_htpercent_d

select '18/Sep/2013',(tmp_ht.ht/tmp_all.amount)*100 from

(select count( distinct a.remote_addr) as ht from dw_access_info_htip a where prtflag_day='18/Sep/2013') tmp_ht

Join

(select count(distinct b.remote_addr) as amount from dw_access_info b where prtflag_day='18/Sep/2013') tmp_all;