3. 查询选修1号 课程的学生学号和成绩,并要求对查询结果按成绩的降序排列,如果成绩相同则按学号的升序排列;
select sno,grade
from sc
where cno='1'
order by grade desc,sno asc
6.查询缺少了成绩的学生的学号和课程号。
select sno,cno
from sc
where grade is null
7.查询每个学生的学号,姓名,选修的课程名,成绩;
select student.sno,sname,cname,grade
from student,course,sc
where student.sno=sc.sno and sc.cno=course.cno
10. 查询每门课程的先行课程的课程名称,学分;
select student.sno,sname,cname,grade
from student,course,sc
where student.sno=sc.sno and sc.cno=course.cno
12.查询每一门课的间接先行课的课程名称;
select first.cno,