Yurttas/PL/DBL/postgres/F/01/Bank/u04.sql

 1/*
 2REM
 3REM u04.sql
 4REM
 5REM Delete all accounts at branches located in Perryridge.
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "bank";
11
12DELETE FROM Depositor
13WHERE branchname IN (SELECT branchname
14                     FROM Branch
15                     WHERE branchcity = 'PerryRidge');