Yurttas/PL/DBL/oracle/F/01/Bank/q070.sql
Jump to navigation
Jump to search
1REM
2REM q070.sql
3REM
4REM Find all customers of the 'Perryridge' branch who have
5REM an account but not a loan.
6REM
7
8SELECT customername
9FROM Depositor
10WHERE branchname = 'Perryridge'
11 AND customername NOT IN (SELECT customername
12 FROM Borrower
13 WHERE branchname = 'Perryridge');