1、
select student. 学号,student.姓名,(select sum(grade.成绩) from grade where grade.学号=student.学号) from stdent order by (select sum(grade.成绩) from grade where grade.学号=student.学号) desc
2、视图的主要语句如下：
select student. 学号,student.姓名 from stdent where (select count(grade.学号) from grade where grade.学号=student.学号 and grade.成绩>90)>2
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024