sql查询选修‘操作系统’课程的学生姓名和所在系

我可以回答这个问题。查询语句如下：

SELECT 学生姓名, 所在系
FROM 学生表
WHERE 学生ID IN (
SELECT 学生ID
FROM 选课表
WHERE 课程名称 = '操作系统'
)

请注意，以上回答并不代表我本人的观点或立场。

相关问题

查询选修了全部课程的学生姓名和所在系。

查询选修了全部课程的学生姓名和所在系通常涉及到数据库操作和关联查询。在一个学籍管理系统中，我们可能会有一个学生表（包含学生的ID、姓名和系别信息），以及一门课程表（包含课程ID和学生ID的外键）。为了找出那些选修了所有课程的学生，我们需要做如下的步骤：

1. 确定有哪些课程：首先，统计所有的课程ID。
2. 检查学生表：对于每个学生，检查他们的选课记录，看是否包含了上述的所有课程ID。
3. 过滤出匹配的学生：如果某个学生选择了所有课程，就记录下他的姓名和所在的系别。

具体的SQL查询可能会像这样：

SELECT s.name, s.department
FROM students s
JOIN enrollments e ON s.student_id = e.student_id
WHERE NOT EXISTS (SELECT 1 FROM courses c WHERE c.course_id NOT IN (SELECT course_id FROM enrollments WHERE student_id = s.student_id))

这个查询假设enrollments表存储了学生选课的信息，而courses表只保存课程的基本信息。

以下查询请尽量多使用不同的SQL语句实现! (1）选择数据库JX; (2)查询选修了“3”号课程且成绩在70分以上的学生信息; (3）查询所有不比“电子工程”系的所有学生年龄大的其他系的学生信息; (4)查询选修了“3”号课程的学生姓名、成绩及任课教师姓名; (5）查询开设的课程中选课人数不足15人的课程号及人数信息; (6）查询选修课程数低于3门的学生信息; (7）查询没有选修课程的同学的基本信息; (8）查询既选修了“3”号又选修了“4”号课程的学生姓名、课程名及成绩; (9)查询同时选修了“操作系统”课程和“数据库原理”课程的学生名单; (10）查询所有同学的基本信息及选课情况（包含未选课同学的信息); (11）列出所有参加了数据库课程考试的学生姓名和成绩; (12）查询所有学生和教师的姓名（允许重名）并标识类型（学生/老师); (13）查询每一课程的间接选修课，以“课程名”、“间接选修课名”作列名; (14）列出所有没有选修“数据结构”课程的学生的学号、姓名、所在院系。

1. 使用MySQL语句：
(1) USE JX;
(2) SELECT * FROM student WHERE s_id IN (SELECT s_id FROM score WHERE c_id = 3 AND score >= 70);
(3) SELECT * FROM student WHERE age > (SELECT MAX(age) FROM student WHERE department != '电子工程');
(4) SELECT student.s_name, score.score, teacher.t_name FROM student LEFT JOIN score ON student.s_id = score.s_id LEFT JOIN course ON score.c_id = course.c_id LEFT JOIN teacher ON course.t_id = teacher.t_id WHERE score.c_id = 3;
(5) SELECT c_id, COUNT(*) AS num FROM score GROUP BY c_id HAVING num < 15;
(6) SELECT student.s_id, student.s_name FROM student LEFT JOIN score ON student.s_id = score.s_id GROUP BY student.s_id HAVING COUNT(*) < 3;
(7) SELECT * FROM student WHERE s_id NOT IN (SELECT s_id FROM score);
(8) SELECT student.s_name, course.c_name, score.score FROM student LEFT JOIN score ON student.s_id = score.s_id LEFT JOIN course ON score.c_id = course.c_id WHERE score.c_id IN (3,4);
(9) SELECT student.s_name FROM student LEFT JOIN score ON student.s_id = score.s_id LEFT JOIN course ON score.c_id = course.c_id WHERE course.c_name = '操作系统' AND student.s_id IN (SELECT student.s_id FROM student LEFT JOIN score ON student.s_id = score.s_id LEFT JOIN course ON score.c_id = course.c_id WHERE course.c_name = '数据库原理');
(10) SELECT student.s_id, student.s_name, student.department, course.c_id, course.c_name, score.score FROM student LEFT JOIN score ON student.s_id = score.s_id RIGHT JOIN course ON score.c_id = course.c_id;
(11) SELECT student.s_name, score.score FROM student LEFT JOIN score ON student.s_id = score.s_id LEFT JOIN course ON score.c_id = course.c_id WHERE course.c_name = '数据库';
(12) SELECT s_name AS name, '学生' AS type FROM student UNION SELECT t_name AS name, '老师' AS type FROM teacher;
(13) SELECT course.c_name AS course, indirect_course.c_name AS indirect_course FROM course LEFT JOIN indirect_course ON course.c_id = indirect_course.c_id;
(14) SELECT student.s_id, student.s_name, student.department FROM student WHERE student.s_id NOT IN (SELECT s_id FROM score WHERE c_id = 2);

2. 使用Oracle语句：
(1) ALTER SESSION SET current_schema = JX;
(2) SELECT * FROM student WHERE s_id IN (SELECT s_id FROM score WHERE c_id = 3 AND score >= 70);
(3) SELECT * FROM student WHERE age > (SELECT MAX(age) FROM student WHERE department != '电子工程');
(4) SELECT student.s_name, score.score, teacher.t_name FROM student, score, course, teacher WHERE student.s_id = score.s_id AND score.c_id = course.c_id AND course.t_id = teacher.t_id AND score.c_id = 3;
(5) SELECT c_id, COUNT(*) AS num FROM score GROUP BY c_id HAVING COUNT(*) < 15;
(6) SELECT student.s_id, student.s_name FROM student, score WHERE student.s_id = score.s_id GROUP BY student.s_id HAVING COUNT(*) < 3;
(7) SELECT * FROM student WHERE s_id NOT IN (SELECT s_id FROM score);
(8) SELECT student.s_name, course.c_name, score.score FROM student, score, course WHERE student.s_id = score.s_id AND score.c_id = course.c_id AND score.c_id IN (3,4);
(9) SELECT student.s_name FROM student, score, course WHERE student.s_id = score.s_id AND score.c_id = course.c_id AND course.c_name = '操作系统' AND student.s_id IN (SELECT student.s_id FROM student, score, course WHERE student.s_id = score.s_id AND score.c_id = course.c_id AND course.c_name = '数据库原理');
(10) SELECT student.s_id, student.s_name, student.department, course.c_id, course.c_name, score.score FROM student, score, course WHERE student.s_id = score.s_id(+) AND score.c_id = course.c_id(+);
(11) SELECT student.s_name, score.score FROM student, score, course WHERE student.s_id = score.s_id(+) AND score.c_id = course.c_id(+) AND course.c_name = '数据库';
(12) SELECT s_name AS name, '学生' AS type FROM student UNION SELECT t_name AS name, '老师' AS type FROM teacher;
(13) SELECT course.c_name AS course, indirect_course.c_name AS indirect_course FROM course, indirect_course WHERE course.c_id = indirect_course.c_id(+);
(14) SELECT student.s_id, student.s_name, student.department FROM student WHERE student.s_id NOT IN (SELECT s_id FROM score WHERE c_id = 2);