Yurttas/PL/DBL/mysql-f-2010/01/BankTwo/q110.sql

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