Yurttas/PL/DBL/oracle/F/01/Movie/q06.sql

 1REM
 2REM q06.sql
 3REM
 4REM List the movies by title, director, and 
 5REM studio that are longer than 'Amistad'
 6REM in the given Movie database.
 7REM
 8
 9SELECT title, studioname, name
10FROM MovieExec, Movie
11WHERE producercn = cn
12  AND length > (SELECT length
13                FROM Movie
14                WHERE title = 'Amistad');