Yurttas/PL/DBL/mssql/F/01/Movies/q08.sql

 1/*
 2REM
 3REM q08.sql 
 4REM
 5REM Modify the relation MovieExec(name, address, 
 6REM cn, networth) by prepending the title Pres.  
 7REM in front of every movie executive who is 
 8REM the president of a studio.
 9REM
10*/
11
12UPDATE MovieExec
13SET name = 'Pres. ' || name
14WHERE cn IN (SELECT presCN
15             FROM Studio);