5.4 人均访问频度 –总访问次数/去重总人数,从访客次数汇总表中查询 select avg(user_times.counts) as user_access_freq from (select remote_addr,counts from t_display_htip union all select remote_addr,counts from t_display_access_dcip) user_times;