Yurttas/PL/DBL/mssql/F/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
11UPDATE Works
12SET salary = salary * 1.03
13WHERE employeename IN (SELECT managername
14                       FROM manages)
15  AND salary * 1.1 > 100000;
16
17UPDATE Works
18SET salary = salary * 1.1
19WHERE employeename IN (SELECT managername
20                       FROM manages)
21  AND salary * 1.1 <= 100000;