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