已知有班级表课程表系部表教师表学期表。根据以上用内连接查询班级名、课程名、教师名学期、学年

SELECT c.class_name, co.course_name, t.teacher_name, s.semester, s.school_year FROM class_table c INNER JOIN course_table co ON c.class_id = co.class_id INNER JOIN teacher_table t ON co.teacher_id = t.teacher_id INNER JOIN department_table d ON c.department_id = d.department_id INNER JOIN semester_table s ON co.semester_id = s.semester_id;