Yurttas/PL/DBL/postgres/F/01/Company-B/q15.sql

 1/*
 2REM
 3REM q15.sql
 4REM
 5REM Give all managers a 10 percent raise.
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companyb";
11
12UPDATE Works
13SET salary = salary * 1.1
14WHERE employeename IN (SELECT managername
15                       FROM manages);