Yurttas/PL/DBL/mssql/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 title, studioname, name
12FROM MovieExec, Movie
13WHERE producercn = cn
14  AND length > (SELECT length
15                FROM Movie
16                WHERE title = 'Amistad');