MYSQL作业
1,查询1832班的成绩信息select *from grade whereclass=1832 ;2，查询1833班，语文成绩大于80小于90的成绩信息 select *from grade where chinese>80and chinese <90 and class=1833;
3，查询学生表中5到10行的数据 select *from grade where class limit 5,6;
4，显示1832班英语成绩为98，数学成绩为77的姓名与学号, select *from grade where English=98and math=77 and class=1832;5，查询出1832班成绩并且按语文成绩排序（降序） select*from grade whereclass=1932 order by Chinese desc;6，查询1833班与1832班，语文成绩与数学成绩都小于80的姓名select *from grade where Chinese <80and math <80;7，查询出没有参加语文考试的学生姓名和班级名称。select *from gradewhere Chinese=null;
8，求出班上语文成绩不及格的学生姓名select *from grade where Chinese<60;
9，求出每个班的数学平均成绩 select avg(math) from grade whereclass=1832;select avg(math) from grade where class=1832;10、求出每个班级语文成绩总分 select sum(Chinese)from gradewhere class=1832; select sum(Chinese)from grade where class=1833;
页:
[1]