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