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

 1REM
 2REM q101.sql
 3REM
 4REM Find all customers with both loan and an account
 5REM at the 'Perryridge' branch.
 6REM
 7
 8(SELECT customername
 9 FROM Depositor
10 WHERE branchname = 'Perryridge')
11INTERSECT
12(SELECT customername
13 FROM Borrower 
14 WHERE branchname = 'Perryridge');