Yurttas/PL/DBL/postgres/F/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
11SELECT current_schema();
12SET search_path to "movies";
13
14SELECT title, studioname, name
15FROM MovieExec, Movie
16WHERE producercn = cn
17  AND length > (SELECT length
18                FROM Movie
19                WHERE title = 'Amistad');