sql增加汇总列和汇总行_SQL：汇总分析

一、聚合查询

聚合函数（汇总函数）：COUNT/SUM/AVG/MAX/MIN

SELECT count(教师姓名) FROM teacher;
-- 如果count输入的是列名,不计算空值null

SELECT count(*) FROM teacher;
-- 如果count输入的是*,会计算全部的行

SELECT sum(成绩) AS 成绩和 FROM score;

SELECT avg(成绩) AS 平均成绩 FROM score;

SELECT max(成绩)AS 最高成绩,min(成绩) AS 最差成绩 FROM score;

SELECT COUNT(DISTINCT 姓名) FROM student;

练习：聚合查询

• 查询课程号为002的总成绩

SELECT SUM(成绩) FROM score
WHERE 课程号 = '002';

• 查询选了课程的学生人数

SELECT COUNT(DISTINCT 学号) AS 学生数 FROM score;