#五个常用聚合函数count(x),max(x),min(x),sum(x),avg(x)；

#五个常用聚合函数count(x),max(x),min(x),sum(x),avg(x);
SELECT COUNT(*)FROM schoolidb where pwd is not null;

SELECT max(age)'最大年龄',min(age)'最小年龄' from schoolidb；

SELECT sum(age)'总年龄' from schoolidb；

SELECT avg(age)'平均年龄' from schoolidb
#利用sum单独计算平均数
SELECT sum(age)//(SELECT count(*) from schoolidb)'sum计算平均年龄',avg(age)'平均年龄' from schoolidb