select sum(total)/count(*) from(
select cast(log_datetime as date format 'YYYYMMDD') logdate,count(*) total
from c_sys_log_tbl
where logdate>='20141201'
group by 1
)log
select cast(log_datetime as date format 'YYYYMMDD') logdate,count(*) total
from c_sys_log_tbl
where logdate>='20141201'
group by 1
)log