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