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

 1/*
 2REM
 3REM u06.sql
 4REM
 5REM Accounts with balances
 6REM over $10,000 receive 6 percent interest,
 7REM while all others receive 5 percent.
 8REM
 9*/
10
11\. set-db.sql
12
13UPDATE Depositor
14SET balance = balance*1.06
15WHERE balance>10000;
16
17UPDATE Depositor
18SET balance = balance*1.05
19WHERE balance<=10000;