Yurttas/PL/DBL/mysql/F/01/00/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
12\. set-db.sql
13
14UPDATE MovieExec
15SET name = 'Pres. ' || name
16WHERE cn IN (SELECT presCN
17             FROM Studio);