Yurttas/PL/DBL/mysql-f-2010/01/Bank/u04.sql

 1/*
 2REM
 3REM u04.sql
 4REM
 5REM Delete all accounts at branches located in Perryridge.
 6REM
 7*/
 8
 9\. set-db.sql
10
11DELETE FROM Depositor
12WHERE branchname IN (SELECT branchname
13                     FROM Branch
14                     WHERE branchcity = 'PerryRidge');