select * from employee t
where exists(select 1 from employee
where street=t.street and
city=t.city and
employee-name=(select top 1 manager-name
from manages
where employee-name=t.employee-name
)
)
SELECT employee-name
FROM employee
WHERE employee-name not in (select employee-name from manages) and
street in(select street from employee e,manages m where e.employee-name=m.employee-name) and
city in(select city from employee e,manages m where e.employee-name=m.employee-name);
select * from employee
where city in(select a.city from company a,works b,manages c
where a.company-name=b.company-name and b.employee-name=c.employee-name)