Yurttas/PL/DBL/oracle/F/01/Company-B/q05.sql
1REM
2REM q05.sql
3REM
4REM Find all employees who live in the same City and
5REM on the same Street as their Manager.
6REM
7
8SELECT E1.employeename
9FROM Employee E1, Manages M, Employee E2
10WHERE E1.employeename = M.employeename
11 AND M.managername = E2.employeename
12 AND E1.Street = E2.Street
13 AND E1.City = E2.City;