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

 1REM
 2REM q110.sql
 3REM
 4REM Find all customers who have an account at all branches
 5REM located in 'Brooklyn'.
 6REM
 7
 8SELECT DISTINCT S.customername
 9FROM Depositor S
10WHERE NOT EXISTS 
11  (SELECT branchname
12   FROM Branch
13   WHERE branchcity = 'Brooklyn'
14     AND branchname NOT IN (SELECT T.branchname
15                            FROM Depositor T
16                            WHERE S.customername = T.customername));