sql문 작성 질문

sql 문작성하다가 않풀리는 문제가 있어서 그러는데요. 좀 풀어주세요. DBMS는 오라클입니다.

데이타베이스는 다음과 같음

employee(employee-name, street, city)

works(employee-name, company-name, salary)

company(company-name, city)

manages(employee-name, manager-name)

1,

Find all employees in the database who live in the same cities and on the same streets as do their managers.

2,

Give all employees of First Bank Corporation a 10 percent raise unless the salary becomes greater than $100,000; in such cases, give only a 3 percent raise.

3,

Add tuples for some employees didn't have their manager. Their manager is KING and KING has no manager.