查询所有同学的平均活动次数 select avg(a.tt) from (select count(*) as tt from student_activity group by uid) as a;