Yurttas/PL/DBL/oracle/F/01/Bank/q111.sql
Jump to navigation
Jump to search
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));