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;