常用的五个聚合函数

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;