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

 1REM
 2REM q04.sql
 3REM
 4REM Find the names and addresses of movie stars
 5REM of movies produced by 'Steven Spielberg'.
 6REM
 7
 8SELECT MS.name, MS.address
 9FROM MovieStar MS, MovieExec ME, Movie M, StarsIn SI
10WHERE ME.name = 'Steven Spielberg'
11  AND ME.cn = M.producercn
12  AND M.title = SI.title
13  AND SI.name = MS.name;