SQL实验指导答案.docVIP

/*1*/select student.sno 学号,sn 姓名,cn 课程, score 成绩 from student,sc,course where score80 and score90 and student.sno=sc.sno and sc.cno=course.cno /*2*/select cn 课程 from sc,course where sc.cno=course.cno group by course.cn having count(*)=4 /*3*/select sn 姓名,age 年龄,dept 系别from student where ageany ( select age from student where dept=信息 ) and dept信息 order by age desc /*4*/select sno 学号, sn 姓名,dept 系别from studentn where age=any ( select age from student where sn=张建国 ) and sn张建国 /*5*/select sn 姓名from student where sno=any ( select sno from sc group by sno