626 views
0 votes
0 votes
What is the output of the following SQL query?

Select * from student S where not exists (select * from course C where C.ID= S.ID and C.GRADE > 40)

(a) Displays all students who never got a grade above 4.0

(b) Displays all students who never got a grade less than equal to 40

(c) Displays all students who got a grade above 4.0

(d) Displays all students who got a grade less than 4.0

How is option A and D different?

1 Answer

0 votes
0 votes
Is answer option a? -Display all students who never got grade above 40

Related questions

0 votes
0 votes
1 answer
3
rayhanrjt asked Jan 6, 2023
719 views
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
2 votes
2 votes
1 answer
4
Subhrangsu asked Jun 18, 2022
431 views
Write SQL query to show all employees hired on June 4,1984 (non-default format)emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)