SQL第十一章上机练习3

最新推荐文章于 2023-03-31 22:48:41 发布

子晴呀

最新推荐文章于 2023-03-31 22:48:41 发布

阅读量1.7k

点赞数

本文链接：https://blog.csdn.net/qq_36074064/article/details/53334967

版权

 上机练习3
  查询学生姓名,所属年级名称 联系电话
  SELECT S.StudentName AS 姓名,G.GradeName AS 年级,S.Phone AS 电话 FROM Student AS S INNER JOIN Grade AS G ON S.GradeId=G.GradeId
  查询年级编号为1的年级名称 科目名称及学时
  SELECT J.SubjectName AS 科目名称,G.GradeName AS 年级,J.ClassHour AS 学时 FROM Subject AS J INNER JOIN Grade AS G ON J.GradeId=G.GradeId WHERE G.GradeId=1
  查询年级编号为1的考试的学生姓名 分数 考试日期
  SELECT S.StudentName AS 姓名,R.StudentResult AS 分数,R.ExamDate AS 考试日期 FROM Result AS R,Student AS S WHERE R.StudentNo=S. StudentNo AND R.SubjectId=1
  查询学号为S1101007的学生参加的考试科目名称 分数 考试日期
  SELECT J.SubjectName AS 科目名称,R.StudentResult AS 分数,R.ExamDate AS 考试日期 FROM Result AS R ,Subject AS J WHERE R.SubjectId=J.SubjectId AND R.StudentNo='S1101007'
  查询参加考试的学生学号 考试科目名称 分数 考试成绩
  SELECT R.StudentNo AS 学生学号,J.SubjectName AS 科目名称,R.StudentResult AS 分数,R.ExamDate AS 考试日期 FROM Result AS R,Subject AS J WHERE R.SubjectId=J.SubjectId