Yurttas/PL/DBL/oracle/F/01/Company-B/q16.sql

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