数据库聚集函数

聚集函数：
SELECT  COUNT(*)
FROM  SC
WHERE Cno=’CS302’;
SELECT MIN(Grade),AVG(Grade),MAX(Grade)
FROM  SC
WHERE Cno=’CS302’;
SELECT Sno,AVG(Grade)
FROM SC
GROUP  BY  Sno;
SELECT Sno,AVG(Grade)
GROUP BY  Sno HAVING  AVG(Grade)>85;