查询学生姓名、所属年级名称及联系电话
SELECT S.StudentName AS 姓名，J.GradeName AS 年级名称，S.Phone AS 电话
FROM Student AS S
INNER JOIN Subject AS J on （S.Gradeld = J.Gradeld）；
查询年级编号为1的年级名称、科目名称和学时
SELECT G.GradName AS 年级名称，J.SubjectName AS 科目名称，J.ClassHour AS 学时
FROM Grade AS G
INNERJOIN Subject AS J on （G.Gradeld = J.Gradeld）
Where G.Gradeld = 1 ；
查询参加科目编号为1的考试的学生姓名、分数、考试日期
SELECT S.StudentName AS 学生姓名，R.StudentResult AS 分数，R.ExamDate AS 考试日期
FROM Result AS R
INNER JOIN Student AS S on (S.StudentNo = R.StudentNo)
WHERE R.SubjectId = 1；
查询学号为S1101007的学生参加的考试科目名称、分数、考试日期
SELECT J.SubjectName AS 考试科目，R.StudentResult AS 分数，R.ExamDate AS 考试日期
FROM Result AS R
INNER JOIN Subject AS J on (R.SubjectId = J.SubjectId)
WHERE R.StudentNo = 'S1101007';
查询参加考试的学生学号，所考科目名称，分数，考试日期
SELECT R.StudentNo AS 学生学号，J.SubjectName AS 科目名称，R.StudentResult AS 分数，R.ExamDate AS 考试日期
FROM Subject AS J
INNER JOIN Result AS R on (J.SubjectId = R.SubjectId)；