--数量求和SELECTcount(*)as'数量总和'FROM`subject`--求的是行数SELECTcount(1)as'数量总和'FROM`subject`SELECTcount(`subject`.subjectno)as'数量总和'FROM`subject`--聚合函数求最大最小,求和,求均值SELECTAVG(result.studentresult)as'平均值'FROM result
SELECTsum(result.studentresult)as'总和'FROM result
SELECTmax(result.studentresult)as'最大值'FROM result
SELECTmin(result.studentresult)as'最小值'FROM result
--结合SELECTAVG(result.studentresult)as'平均值'FROM result
GROUPBY result.studentresult
HAVING 平均值>70;