学生成绩单整理

今晚作业：
1、查询1832班的成绩信息
2，查询1833班，语文成绩大于80小于90的成绩信息
3，查询学生表中5到10行的数据
4，显示1832班英语成绩为98，数学成绩为77的姓名与学号, 5，查询出1832班成绩并且按语文成绩排序（降序） 6，查询1833班与1832班，语文成绩与数学成绩都小于80的姓名。 7，查询出没有参加语文考试的学生姓名和班级名称。
8，求出班上语文成绩不及格的学生姓名
9，求出每个班的数学平均成绩
10、求出每个班级语文成绩总分 --涉及到每个的时候都需要分组

创表结构create table student(number int(20) primary key
auto_increment,name varchar(10),score int(20),chinese
int(20),maths int(20),english int(20),class int(4));
添加一个首行数据insert into student values(1,'zhangsan',263,88,77,98,1832);
连续添加几个insert into student values(2,'zhangsi',264,87,79,98,1832),(3,'zhang1',222,70,60,60,1833),(4,'zhang2',234,99,77,55,1832),(5,'zhangsi3',284,77,98,88,1832),(6,'zhangsi5',254,88,77,80,1833);
1.  1.1select chinese,maths,english from student whese class=1832;
1.  1.2select *from student where class=1832;
2.select *from student where class=1833 and chinese>80 and chinese<90;
3.select*from student number limit 4,6;
4.select name,number from student where class=1832 and english=98 and maths=77;
5.select*from student where class=1832 order by chinese desc;
6.select name from student where chinese<80 and maths<80;
7.select name,class from student where chinese is null;
8.select name from student where chinese<60;
9.select avg(maths),class from student group by class;
10.select sum(chinese),class from student group by class;