Consider the following relational schema.
student(ID,NAME,DEPT) is student relation
Course(CID,ID, GRADE, DEPT) is course enroll relation
What is output of following SQL query
Select * from student S
Where not exists
(Select * from course C where C.ID=S.ID and C.GRADE>4.0)
1
Displays all students who never got a grade above 4.0
2
Displays all students who never got a grade less than or equal to 4.0
3
Displays all students who got a grade above 4.0
4
Displays all students who got a grade less than 4.0