GROUP BY 分组查询

GROUP BY 分组查询
使用GROUT BY关键字对查询结果分组：
对所有的数据进行分组统计
分组的依据字段可以有多个，并依次分组
与HAVING结合使用，进行分组后的数据筛选

例：按照不同的课程分组，分别算出其平均分、最高分和最低分，对于低于60分平均分的不予显示：
SELECT COUNT(*)
FROM student

SELECT SUM(result)
FROM result

SELECT AVG(result)'平均分',MAX(result)'最高分',MIN(result)'最低分'
FROM result

SELECT b.subjectName AS '课程名称',MAX（result）'最高分',MIN(result) '最低分',AVG（result）'平

均分'
FROM result AS a INNER JOIN subject AS b ON a.subNo = b.id
GROUP BY b.subjectName
HAVING AVG(result)>=75

SELECT b.subjectName AS '课程名称'
FROM result AS a INNER JOIN subject AS b ON a.subNo = b.id
GROUP BY b.subjectName
HAVING AVG(result)>=75