Yurttas/PL/DBL/mysql-f-2010/01/Company-B/q16.sql

 1/*
 2REM
 3REM q16.sql
 4REM
 5REM Give all managers a 10 percent raise unless the 
 6REM salary becomes greater than $100,000. In such cases,
 7REM give only a 3 percent raise.
 8REM
 9*/
10
11\. set-db.sql
12
13UPDATE Works
14SET salary = salary * 1.03
15WHERE employeename IN (SELECT managername
16                       FROM Manages)
17  AND salary * 1.1 > 100000;
18
19UPDATE Works
20SET salary = salary * 1.1
21WHERE employeename IN (SELECT managername
22                       FROM Manages)
23  AND salary * 1.1 <= 100000;