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;