Yurttas/PL/DBL/mysql-f-2010/01/Movies/q06.sql

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