Yurttas/PL/DBL/oracle/F/01/Company-B/q03.sql

 1REM
 2REM q03.sql
 3REM
 4REM Find the name, street, and city of of all employees who
 5REM work for 'First Bank Corporation' and earn more than $10,000.
 6REM
 7
 8SELECT *
 9FROM Employee
10WHERE employeename IN (SELECT employeename 
11                       FROM Works 
12                       WHERE companyname='First Bank Corporation' 
13                         AND salary > 10000);