Yurttas/PL/DBL/mssql/F/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
11UPDATE Depositor
12SET balance = balance*1.06
13WHERE balance>10000;
14
15UPDATE Depositor
16SET balance = balance*1.05
17WHERE balance<=10000;