11上机练习3

USE MySchool--查询学生姓名、所属年级名称及联系电话。SELECT S.StudentName AS 姓名,G.GradeName AS 年级,S.Phone AS 电话FROM Student AS SINNER JOIN Grade AS G ON S.GradeId=G.GradeIdSELECT S.StudentName AS 姓名,G.GradeName AS 年级,S.Phone AS 电话FROM Student AS S,Grade AS G WHERE S.GradeId=G.GradeId--查询年级编号为1的科目名称、年级名称及学时。SELECT J.SubjectName AS 科目名称,G.GradeName AS 年级,J.ClassHour AS 学时FROM Subject AS JINNER JOIN Grade AS G ON J.GradeId=G.GradeIdWHERE G.GradeId=1SELECT J.SubjectName AS 科目名称,G.GradeName AS 年级,J.ClassHour AS 学时FROM Subject AS J,Grade AS GWHERE J.GradeId=G.GradeId AND G.GradeId=1--查询参加科目编号为1的考试的学生姓名、分数、考试日期。SELECT S.StudentName AS 姓名,R.StudentResult AS 分数,R.ExamDate AS 考试日期FROM Result AS RINNER JOIN Student AS S ON R.StudentNo=S. StudentNoWHERE R.SubjectId=1SELECT 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 RINNER JOIN Subject AS J ON R.SubjectId=J.SubjectIdWHERE R.StudentNo='S1101007'SELECT J.SubjectName AS 科目名称,R.StudentResult AS 分数,R.ExamDate AS 考试日期FROM Result AS R ,Subject AS JWHERE R.SubjectId=J.SubjectId AND R.StudentNo='S1101007'--查询参加考试的学生学号、所考科目名称、分数、考试日期.SELECT R.StudentNo AS 学生学号,J.SubjectName AS 科目名称,R.StudentResult AS 分数,R.ExamDate AS 考试日期FROM Result AS RINNER JOIN Subject AS J ON R.SubjectId=J.SubjectIdSELECT R.StudentNo AS 学生学号,J.SubjectName AS 科目名称,R.StudentResult AS 分数,R.ExamDate AS 考试日期FROM Result AS R,Subject AS J WHERE R.SubjectId=J.SubjectId