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

 1REM
 2REM q111.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 ((SELECT branchname
11                   FROM Branch
12                   WHERE branchcity = 'Brooklyn')
13                  MINUS
14                  (SELECT T.branchname
15                   FROM Depositor T
16                   WHERE S.customername = T.customername));