MySQL聚合函数的使用方法

select count(*) from student where pwd is not null;

select max(age) '最大年龄',min(age) '最小年龄' from student;

select avg(age) '平均年龄',from student;

select sum(age) '总年龄', from student;

select avg(age) '平均年龄',sum(age)/(select count(*) from student) 'sum计算平均年龄' from student;