SQL随笔

1、怎么用一条sql语句查出学生表成绩小于60为不及格60-80为良好80-90为优秀？
    SELECT sname,CASE WHEN score<60 THEN '不及格' WHEN score>=60 AND score<80 THEN '良好' WHEN score>=80 THEN '优秀' END AS 成绩情况 from student
2、用SQL语言查询各个班级的平均成绩？
     SELECT classname,AVG(score) FROM student GROUP BY classname