mysql数据

1、select chinese,maths,english from student where class=1832；

2、select chinese,maths,english from student where class=1833 and chinese>80 and chinese<90；

3、select*from student where name limit 4,6；

4、select number,name from student where english=98 or maths=77;

5、 select chinese,maths,english from student where class=1832 order by chinese desc;

6、 select name from student where class<1834 and 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*from student group by class having avg(maths);

10、select*from student group by class having sum(chinese);