查询选修了“3”号课程的学生姓名、成绩及任课教师姓名; .

假设学生表为students，选课表为course_selections，课程表为courses，教师表为teachers，可以使用以下SQL查询语句： SELECT s.name AS student_name, cs.score, t.name AS teacher_name FROM students s INNER JOIN course_selections cs ON