查询至少选修了201215122号学生所选的全部课程的学生的学号与姓名的代码

SELECT s.s_id, s.s_name
FROM student s
WHERE NOT EXISTS (
SELECT c.c_id
FROM course c
WHERE c.c_id NOT IN (
SELECT sc.c_id
FROM sc
WHERE sc.s_id = '201215122'
)
AND c.c_id NOT IN (
SELECT c_id
FROM sc
WHERE s_id = s.s_id
)
)