Yurttas/PL/DBL/oracle/F/01/Bank/q070.sql

 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');