SELECT
sname
FROM
student
WHERE
NOT EXISTS (
SELECT
*
FROM
course
WHERE
NOT EXISTS (
SELECT
*
FROM
sc
WHERE
student.sno = sc.sno
AND sc.cno = course.cno
)
)
SELECT
sname
FROM
student
WHERE
NOT EXISTS (
SELECT
*
FROM
course
WHERE
NOT EXISTS (
SELECT
*
FROM
sc
WHERE
student.sno = sc.sno
AND sc.cno = course.cno
)
)