1mysql查询S1年级开设课程的课程名称及学时2mysql查询学生姓名、所属年级名称及联系电话3mysql查询参加课程编号为1的课程考试的学生姓名、分数、考试日期4查询G1263458同学参加的考试科目名称、分数和考试日期5mysql查询所有考试成绩达到90分的成绩信息显示学生学号、课程名称、分数和考试日期6mysql查询所有考试成绩不及格学生的信息显示学号、姓名、考试科目名称及成绩7mysql

SELECT course_name, course_hours FROM course WHERE grade = 'S1';
SELECT student.name, grade.grade_name, student.phone_number FROM student INNER JOIN grade ON student.grade_id = grade.grade_id;
SELECT student.name, score.score, exam.exam_date FROM student INNER JOIN score ON student.student_id = score.student_id INNER JOIN exam ON score.exam_id = exam.exam_id WHERE exam.course_id = 1;
SELECT course.course_name, score.score, exam.exam_date FROM student INNER JOIN score ON student.student_id = score.student_id INNER JOIN exam ON score.exam_id = exam.exam_id INNER JOIN course ON exam.course_id = course.course_id WHERE student.student_id = 'G1263458';
SELECT student.student_id, course.course_name, score.score, exam.exam_date FROM student INNER JOIN score ON student.student_id = score.student_id INNER JOIN exam ON score.exam_id = exam.exam_id INNER JOIN course ON exam.course_id = course.course_id WHERE score.score >= 90;
SELECT student.student_id, student.name, course.course_name, score.score FROM student INNER JOIN score ON student.student_id = score.student_id INNER JOIN exam ON score.exam_id = exam.exam_id INNER JOIN course ON exam.course_id = course.course_id WHERE score.score < 60;
SELECT student.student_id, student.name, course.course_name, score.score, exam.exam_date FROM student INNER JOIN score ON student.student_id = score.student_id INNER JOIN exam ON score.exam_id = exam.exam_id INNER JOIN course ON exam.course_id = course.course_id WHERE course.course_name = 'C语言程序设计'