select avg(numUser) as averageUsers from ( select date_format(visit_time,'%Y-%m-%d') as visit_date, count(distinct user_id) as numUser from table where datediff(curdate(),visit_date)<=30 group by visit_date );