Question: c ) ( 5 pts ) Consider the following SQL query: SELECT E . ename FROM Emp AS E WHERE E . salary > ALL
c pts Consider the following SQL query:
SELECT Eename
FROM Emp AS E
WHERE Esalary ALL SELECT Dbudget
FROM Dept AS D Works AS W
WHERE Eeid Weid AND Ddid Wdid
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
