Question: c ) ( 5 pts ) Consider the following SQL query: SELECT E . ename FROM Emp AS E WHERE E . salary > ALL

c)(5 pts) Consider the following SQL query:
SELECT E.ename
FROM Emp AS E
WHERE E.salary > ALL ( SELECT D.budget
FROM Dept AS D, Works AS W
WHERE E.eid = W.eid AND D.did = W.did)
Which of following best explain the meaning of this expression?
I. Print the name of each employee whose salary exceeds the budget of one
department that he or she works in.
II. Print the name of employee whose salary is less that the budget of all of the
departments that he or she works in
III. Print the name of each employee whose salary exceeds the budget of all of the
departments that he or she works in.
IV. Both I and II
V. Both I and III
VI. Both II and III
VII. All of the above
VIII. None of the above
Answer: ____

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!