select tmp.day,tmp.remote_addr,tmp.acc_cnt from (select ‘2013-09-18’ as day,remote_addr,count(session) as acc_cnt from click_stream_visit group by remote_addr) tmp where tmp.acc_cnt>1;