Yurttas/PL/DBL/mysql-f-2010/01/Movies/q04.sql

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