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;