Consider the following releational schema:
STUDENT(SNO––––––,SNAME,DEPT)
ENROLL(CNO,SNO–––––––––––––, GRADE)
COURSE(CNO––––––,DEPT)
PREREQ(CNO,PNO–––––––––––––)
Keys are underlined. The column ENROLL (SNO) is a foreign key referencing STUDENT(SNO). All the occurrences of the columns CNO and PNO, except for the one in COURSE, are foreign keys referencing COURSE(CNO)
SELECT E1.CNO, S.SNAME
FROM ENROLL E1, STUDENT S
WHERE E1.SNO = S.SNO
AND NOT EXISTS (SELECT * FROM ENROLL E2
WHERE E2.CNO = E1.CNO
AND E2.GRADE >E1.GRADE)
What is the output of the Query?