聚合函数——count(),max(),min(),avg(),sum()

具体操作如下图

#聚合函数数量count(),最大max(),最小(),平均数(),求和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;