sql

SELECT sName
FROM student
WHERE NOT EXISTS (SELECT *
FROM course
NATURAL JOIN department
WHERE department.dName = '信息学院'
AND NOT EXISTS (SELECT *
FROM sc
WHERE course.cNo = sc.cNo
AND student.sNo = sc.sNo));