Yurttas/PL/DBL/oracle/F/01/Company-B/q03.sql
Jump to navigation
Jump to search
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);