d$)(5$ pts$)$ Consider the following SQL query:

SELECT E$.$eid, E$.$ename

FROM Emp AS E$,$ Dept AS D

WHERE E$.$eid $=$ D$.$managerid

GROUP BY E$.$eid, E$.$ename

HAVING $($D$.$budget $>=1000000)$ AND $($D$.$budget $<=5000000)$

Which of following best explain the meaning of this expression?

I. Find the eid and enames of managers who works only on departments with budgets

between $$1$ million and $$5$ million.

II$.$ Find the eid and enames of employees who manage only departments with budgets

between $$1$ million and $$5$ million.

III. Find the eid and enames of managers who manage only departments with budgets

larger than $$1$ million, but at least one department with budget less than $$5$ million.

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: $\_\_\_\_$