Question

实验中的SQL部分 学生表:Student(Sno,Sname,Ssex,Sage,Sdept) 课程

Answer 1

1.SELECT * FROM Student;

2.SELECT Sno,Sname,Sage FROM Student WHERE Sdept='信息系';

3.SELECT Sno FROM SC WHERE Grade75;

17.SELECT Sno FROM (SELECT TOP 1 S.Sno,AVG(Grade) FROM Student S,SC WHERE S.Sno=SC.Sno GROUP BY S.Sno ORDER BY AVG(Grade)),

20 SELECT TOP 3 Sno,Sname,Sdept FROM Student S,Course C,SC WHERE S.Sno=SC.Sno AND C.Cno=SC.Cno AND C.Cname='高等数学' ORDER BY SC.Grade;