Yurttas/PL/DBL/oracle/F/01/Movie/q06.sql
Jump to navigation
Jump to search
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');