SELECT count(*) FROM student WHERE pwd is not null;
#max与min
SELECT MAX(age)'最大年龄',MIN(age)'最小年龄' FROM student;
#平均年龄
SELECT AVG(age)'平均年龄' from student;
#年龄总和
SELECT SUM(age)'年龄总和' from student;
#利用sum计算平均数
SELECT AVG(age)'平均年龄',(SELECT count(*) FROM student) 'sum的平均年龄' FROM student;