Problem 1.
Emp(eid: integer, ename: string, age: integer, salary: real)
Works(eid: integer, did: integer, pct time: integer)
Dept(did: integer, dname: string, budget: real, managerid: integer)
1. Find the managerids of managers who manage only departments with budgets greater than $1 million.
SELECT DISTINCT D1.managerid FROM Dept D1 WHERE 1000000 < ALL ( SELECT D2.budget FROM Dept D2 WHERE D2.managerid = D1.managerid );
2. Find the enames of employees that work in more than one department.