例21.sql

介绍了一些数据库中常用的语句

Select  学号 ,  AVG(成绩) AS 平均分
     From  选课
     GROUP BY  学号
     HAVING  AVG(成绩)>=80 
     ORDER BY  AVG(成绩) DESC