MySQl 聚合函数

聚合函数会涉及的5个单词：count()数量  max()最大  min()最小 avg()平均 sum()求和

select count(*)'数据总条数' from student where pwd is not null;
select max(age)'年龄最大' from student;
select min(age)'年龄最小' from student;
select avg(age)'平均年龄' from student;
select sum(age)'年龄总和' from student;
select sum(age)/(select count(*)'数据总条数' from student)'平均年龄' from student;