5.9-作业-29班宋建业

1、select * from stu where class=1832;

2、select * from stu where chinese between 81 and 89 group by class having class=1833;

3、select * from stu limit 4,6;

4、select name,num from stu where english=98 and maths=77 group by class having class=1832;

5、select * from stu where class=1832 order by chinese desc;

6、select name from stu where chinese<80 and maths<80 group by class having class=1832 or class=1833;

7、select name,class from stu where chinese is null;

8、select name from stu where chinese<60;

9、select class,avg(maths) from stu group by class;

10、select class,sum(chinese) from stu group by class;

11、update stu set chinese=60 where chinese<60;

12、select age,name from stu where chinese>70 and maths>70 and english>70;

13、select name,class from stu where english>70 and (maths>60 or chinese>60);

14、select class,count(*) from stu group by class;

15、select class,count(*) from stu where maths>80 group by class;

17、alter table stu add (sex int(20),height int(20),weight int(20));